View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pantelis pantelis is offline
external usenet poster
 
Posts: 27
Default 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