View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default VBA - Protecting from Save

Another approach would be mark the template as Read-Only using Windows
explorer, right clicking on the file and selecting options.

--
Regards,
Tom Ogilvy

"HRobertson" wrote in message
...
Is there a code to write that will allow users of the file
to only SAVE AS, and not SAVE? Please help, I'm having
trouble preventing people from using SAVE on template
forms I built, and therefore their info. is there every
time I open the files. Thank you very much!