Disable Macro Problem

  • Thread starter Thread starter pantelis
  • Start date Start date
P

pantelis

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
 
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
 
Back
Top