Disable "Save As" Option

A

Andy T

Is there anyway of disabling the File/ Save As option from the toolbar in
Excel. I want to force the user to use a CommandButton save macro in the
form I have developed.

Thanks
 
H

Harald Staff

Hi Andy

It's a little dangerous, given that the user may have multiple open files
and your code may err while restoring the functionality. However, your
workbook has a Before_Save event in the ThisWorkbook module that will give
you total control of the saving process. Like, set Cancel to true there and
call your own macro.

HTH. Best wishes Harald
 
Top