Excel Macro to Disable the Save As feature
Excel Macro to Disable the Save As feature in Excel
Private Sub Workbook_BeforeSave (ByVal SaveAsUI As Boolean, Cancel As Boolean)
'This macro disables the "Save As" Feature in Excel
'This means that a user will not be able to save this
'workbook(file) under a different name or in a different location
'This MUST be placed in "ThisWorkbook" and NOT in a Module.
If SaveAsUI = True Then Cancel = True