View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default how to save /make excel file as read only?

With the file closed

Setattr "fullname" vbReadonly

Regards,
Peter T

"Rich" wrote in message
...
Hello,

I need to save an excel file as a read only file for viewing from a

website.
How to save it as read only? I really need to save the file as an xml

file.
Excel already does that, and the xml file opens up inside IE. But I need
that file to be read only. I am thinking that if I make the excel file

read
only - when I save it down as xml the xml will copy the read only

attribute.
But how to make the file read only?

Thanks,
Rich