Ps. Lots of times, I just save my file normally and then use windows explorer
to mark the file Readonly.

Rightclick on the filename in windows explorer and choose properties to find
that option.

Excel won't even ask the user for a password to modify, but will still open the
file in readonly mode.

But all that other stuff (save as a new name and delete the original and rename
the new copy) still puts your file at risk.

By putting the file on a server that is readonly to the users (you'll want
access for you and trusted individuals), excel will open the file in readonly
mode. And your file will be safe from your average (untrustworthy <vbg) user.



jatman wrote:

Excel File, have code to save file name based on cell value, saving to a
target directory...

can it be saved so that it is read only, preventing changes?

thank you,

jat

--

Dave Peterson