How about just using windows explorer to do it?

Open windows explorer
and with that file closed
rightclick on it, choose properties and on the general tab mark it readonly.

Another alternative is to:
file|SaveAs|General options (top left corner)
Give it a password to modify.

The users will be prompted each time it opens with that second suggestion.

Budget Programmer wrote:

Hello,
I have a macro that creates and report in a workbook. Works fine. I place
it on the shared drive, no problem. However, once it's there (or As it's
being saved), I'd like to have the "windows" property of "Read Only"
selected. How would I go about that from Excel VBA?
Thanks for your help.
--
Programmer on Budget

--

Dave Peterson