save as read only

[Guest]

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

 

[Rob]

Just a suggestion.....It may be better to password protect all the cells and
the worksheets before saving.

There is a "Read Only Recommended" option when you go to Save As > Tools >
General, but I don't think that's restrictive enough....at least in my
version, 2000.

Rob

 

[Dave Peterson]

Record a macro when you do:
File|SaveAs|Tools|General Options
give it a nice memorable password to modify.

And you'll see the code you need to update your existing procedure.

But user's will be able to open it in readonly mode (and make changes that can
be saved elsewhere), though.

In fact, they could make changes, save them as a new name, and then delete your
file and rename their file to your old file's name.

If you think that they're "bad" enough to do this, you may want to ask your IT
department for a drive that only trusted people have write access to.

 

[Dave Peterson]

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.