View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default protect my .xls sheet from being“modified” and“saved as”

I don't think you can.

Any solution would rely on macros and macros could be disabled. Heck, the user
could just use windows explorer to copy that file anywhere they wanted.

EFT wrote:

I need to protect my .xls sheet from being €śmodified€ť and €śsaved as€ť
How could I do this using the VBA for that?
All of which i'm asking you, How to protect my sheet from being "saved as"
when it's in the read only mode.

Thanks for your help.


--

Dave Peterson