View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LennyG LennyG is offline
external usenet poster
 
Posts: 8
Default Protect Worksheet

I wrote a macro to select certain options when reports on my worksheets are
being
printed. The sheets are then protected and when the macro is run, a message
appears stating that the commands could be accessed if the password is
entered (to remove the protection). How could I get the protection to
remain and get the macro to work.
Thanks
Lennox