Deactivating Save options

I have a worksheet that has a button for users that saves the workbook after running a macro.

If they use the normal save methods (File > save; or the save icon in the menu bar) it obviously by-passes the macro.

Is there any way i can deactivate the normal save options to force users to use the button I set up for them?


(My first idea was to make any form of save run the macro, but i have two different "save macros" i want to run with a button for each...)


Thanks in advance for any help!

You can set a public flag in your save code, and clear it following your custom save.

In the Workbook_BeforeSave event, cancel the save if the flag is not set.

Originally Posted by shg

You can set a public flag in your save code, and clear it following your custom save.

In the Workbook_BeforeSave event, cancel the save if the flag is not set.

That sounds great - exactly what i need. But i have no idea how to do that...