Force File Read-Only?

Ed · Jul 21, 2003

I am using Win2000 and Excel 2000. I put a workbook onto a company-wide
server, and I'm afraid users are going to screw it up so another user opens
a file of garbage. The users are going to have to be able to filter and
hide columns and rows.

I can right-click on the file and set its property to Read-Only, so no
changes get saved when the file closes. But I'm concerned that someone will
simply turn it off. Is there any way to code a BeforeOpen action that will
set this property to Read-Only, regardless of how it was checked/unchecked
when the user opened it?

Ed

Bill Lunney · Jul 21, 2003

Sounds like you're better just blocking the Save event altogether.
Something like this added to the workbook code module will do the job.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub

This has the advantage that you can specifiy the criteria used to decide if
a file can be saved.

http://www.billlunney.com/Excel/FAQ/DisplayFAQ.ascx?ExcelFAQID=211

--

Regards,

Bill Lunney
www.billlunney.com