Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macro Problem
Hi all,
I've set up a sheet so that it askes for a password when you enter, however this only works when you enable macros, if you select disable macro it will let you into the worksheet with no problem. Could you please provide me with some input on how to protect this worksheet when the disable macro option is selected. Thanks in advance for all your help Pantelis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macro Problem
If you want to hide the workshet, then see the next post
(Preventing someone from unding a s.) If you want to keep the sheet visible, but stop the user changing it then use sheet protection (Tools/Protection/Protect sheet). If there are certain cells that you want to allow the user to change, then unlock them before you protect the sheet (Format/Cells, Protection tab) Cheers, Dave -----Original Message----- Hi all, I've set up a sheet so that it askes for a password when you enter, however this only works when you enable macros, if you select disable macro it will let you into the worksheet with no problem. Could you please provide me with some input on how to protect this worksheet when the disable macro option is selected. Thanks in advance for all your help Pantelis . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
Disable Esc-key - macro | Excel Discussion (Misc queries) | |||
How to disable the Macro? | Excel Discussion (Misc queries) | |||
Disable macro at runtime | Excel Worksheet Functions | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) |