View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Setting Read Only on save.

If the file is to be readonly, then you would not be able to save it. I
doubt you can set the readonly attribute of the file from within the file
itself.

--
Regards,
Tom Ogilvy


"Darren Lord" wrote in message
...
Hi all,

I want to set the read only attribute to a file automatically on save. Can
anyone help me determine the line that I need to put in the auto_close
macro.

Needs to be done in this macro as I want it to execute everytime that
(multiple) users exit the file.

Cheers, Darren.