+ Reply to Thread
Results 1 to 2 of 2

Allow cell selecting but disable manual cell editing

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Allow cell selecting but disable manual cell editing

    Hello all,

    My sheet contains an area in which I want the user to edit cells by use of a UF only. (range F9:S100)
    By double clicking a cell the UF will popup, so the user needs to be able to select the cell.

    All other cells on the sheet are protected and are not able to be selected.
    I hoped the following would work for a particular range only, but it does not

    Please Login or Register  to view this content.
    Any ideas?

  2. #2
    Registered User
    Join Date
    09-20-2016
    Location
    bhopal
    MS-Off Ver
    2003
    Posts
    17

    Re: Allow cell selecting but disable manual cell editing

    Will u please attach sample file..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] protect sheet disable editing of non empty cell
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2016, 08:21 AM
  2. Need Help to disable cell editing if putting current date + two days
    By Louapril in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2016, 02:54 PM
  3. Editing Code: Selecting multiple items in a cell via data validation
    By baker2145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 06:13 PM
  4. How to disable direct cell editing by typing, but allow formulas?
    By matkiros in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2012, 07:04 AM
  5. disable cell content editing, but allow row/column removal
    By Heliux in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2009, 11:18 AM
  6. Disable Editing a Cell Without Protecting the Worksheet
    By akabraha in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2008, 06:46 PM
  7. Disable CommandBar buttons while editing the cell
    By Vinit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1