Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save as read only
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
save as read only
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 "jatman" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
save as read only
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. 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
save as read only
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
cannot edit and save | New Users to Excel | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |