Thread: Protect macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ST
 
Posts: n/a
Default Protect macro

I want to protect rather hide my macro from users and at the same time
I want them to see and use workbook and save the work.When I protect my
project in VBE it does not allow me to save /and save as beacause it
asks first unprotect the sheet first.If I save the work book by putting
a password for read/modify access it exposes my macro to the users.

Any quick solution will be highly appreciated.
ST