Why disable the save and saveas buttons. (did you disable Ctrl+S?) Just
intercept the save in the Workbook_BeforeSave event and handle the naming
there.
(cancel the save and manage it yourself)
--
Regards,
Tom Ogilvy
"Stuart" wrote in message
...
User opens a workbook containing a single sheet.
Code has disabled File Save and Save As.
I need to allow the user to Save if they wish!
Is the best way a button... if so how, please?
I need to ensure the saved name is different from
the filename opened, and that they can choose their
save directory.
If they Cancel then the workbook is not to be saved.
Can you help, please?
Regards.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004