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.
--
George Nicholson
Remove 'Junk' from return address.
Brian said:
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.
