how to save /make excel file as read only?
 

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

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

how to save /make excel file as read only?
 

Thanks. That worked perfectly

Rich

"Peter T" wrote:

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