Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent selecting locked cells
I would like to be able to prevent users from selecting locked cells in a
worksheet and to do this have used the EnableSelection property with the Protect method. The problem I had was that when the workbook is closed and re-opened the locked cells are still selectable. Having looked at previous posts I see that this is because the EnableSelection property is not persistent. However, it does seem to be persistent if I manually protect the worksheet so that only unlocked cells can be selected. How come this can't be achieved with VBA? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cursor selecting cells locked on... | Excel Discussion (Misc queries) | |||
Prevent Users from Selecting Cells | Excel Worksheet Functions | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) | |||
Selecting only locked cells | Excel Programming |