G
Guest
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?
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?