Check out some similar questions!

kvinay_00 · Jul 2, 2009, 03:31 AM

Is there any way to disable only "Save As" option (Save option works)?

Thanks

JBeaucaire · Jul 2, 2009, 07:52 AM

Put the following macro into the ThisWorkbook module of the book:

Code:

Option Explicit

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    If SaveAsUI Then
        MsgBox "The 'Save As' function has been disabled." & Chr(10) & _
            "Only 'Save' will work.", vbInformation, "Save As Disabled"
        Cancel = True
    End If
End Sub

(source)

kvinay_00 · Jul 2, 2009, 11:03 PM

Thank you !