| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locked cell without alert
I use a workaround where I dont allow the users to select the locked
cells. This can be enabled while protecting the worksheet using the menu. or programtically sheet1.EnableSelection = xlUnlockedCells sheet1.Protect Hope it helps. Regards, Jayant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activating a sound alert on cell value | Excel Discussion (Misc queries) | |||
| locked cell not locked | Excel Discussion (Misc queries) | |||
| alert before deleting contents of a cell | Excel Discussion (Misc queries) | |||
| can I set-up an alert in a cell? | Excel Discussion (Misc queries) | |||
| Alert If Cell Value Is a Certain Value | Excel Discussion (Misc queries) | |||
Threaded Mode
