Disable SaveAs On Toolbar But Allow in Macro

[djfatboyfats]

Good afternoon,

I'm trying to restrict my agents from pressing "save as" in excel instead of pressing my Save Macro button. I added a bit of code to a "beforesave" action which stopped the agent from having the ability to "save as" but it has also stopped my Save Macro button code from running when it gets to the "save as" part. What can I do to disable the agent from pressing "save as" from the file menu but allow the code to run from the macro?

Stop Save As

Please Login or Register  to view this content.

Save Macro Button

Please Login or Register  to view this content.

Thanks in advance

DJ

[6StringJazzer]

One way to do this is in the module containing your SaveAs code to add a Public variable

Please Login or Register  to view this content.

Then in SaveAs, make these changes before and after the call to SaveAs (I recommend against using SaveAs as a Sub name--it's valid but easily confused with the SaveAs method of Workbook)

Please Login or Register  to view this content.

Then in the event handler:

Please Login or Register  to view this content.