| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keep Cell Unlocked but Don't Allow User to Change the Text in Cell
I have a UserForm that adds and edits data on a worksheet. To load the
UserForm the user Double Clicks a cell that contains a reference number, the macro searchs for the reference number in another worksheet and loads the UserForm with the associated data. I have to keep the cell unlocked so the user can double click it. The problem is that it is possible for the user to delete the reference number. Is there a way to keep that cell from being changed and still allow my Double Click Event to work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to protect cell formatting in an unlocked cell? | Excel Discussion (Misc queries) | |||
| How to change font colour in unlocked cell of protected sheet | Excel Discussion (Misc queries) | |||
| How was user able to (accidentally) change an unlocked cell to loc | Excel Worksheet Functions | |||
| Using DTPicker to change date in a cell when user selects cell? | Excel Programming | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
