Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a budget sheet which allows restricted access (users without
password can only update certain cells). I want to be able to lock the sheet/unlock the sheet using buttons. I have tried a Macro but after the first time it only protects the sheet without a password. Can any one tell me how to correct this without having to go to Tools, Protection, etc etc every time as users might forget to do this. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
about protection | Excel Discussion (Misc queries) | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |