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

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


.