Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've made a worksheet (Excel 2003) that I have protected. Most cells are
locked, only some are accessible to the people making use of it. I've set the Worksheet protections (Tools - Protection - Protect Sheet) to only allow selection of unlocked cells, locked cells should not be selectable. However, after saving the worksheet, quitting Excel and starting it up again, Excel seems to return to the default state of allowing people to select both Unlocked and Locked Cells. As such, it seems to ignore the Worksheet Protection I set earlier. Am I missing a (logical) step here? Or alternatively, if this is an 'undocumented feature' of Excel, is it possible to add some VBA code that simply takes away the possibility to select Locked Cells when the sheet is loaded? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
worksheet protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |