| | |
|
|
|
Saving |
|---|
| message from =?Utf-8?B?QnJpYW4=?= on 27 May 2004 |
How can I force users to perform a Save as? I would like to save the workbook's orginal state everytime a user opens, modifies, and / or saves. I'd like to force them to do a Save as, rather than a save....which would change the workbook.
thanks
|
| George Nicholson replied to =?Utf-8?B?QnJpYW4=?= on 27 May 2004 |
Wrong newsgroup. This is for Access db questions, and you want Excel.
(microsoft.public.excel or microsoft.public.excel.misc)
Having said that, one way would be to save the workbook with "Read-Only
Recommended" enabled and a password specified. Without a password, this
allows users ReadOnly rights: if they want to save they have no choice but
to use SaveAs. You keep the password for yourself.
In Excel XP: Tools>Options>Security: FileSharingSettingsForThisWorkbook
Another approach would be to set up your workbook as a template. See online
help for more info on that topic. It may not be appropriate for your
situation.
|
|
Archived message: Saving (Microsoft Access Forms)
