Disable save and save as

[greatcookies]

How can I disable the save and save as function in excel? I have code written to save automatically upon exiting.

Thanks!

 

[Oaktree]

Put something like this in the ThisWorkbook module:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True
MsgBox "This file uses a custom save method. When you exit the file, your file will automatically be saved."
End Sub