Log in

View Full Version : Disable Save As option


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:

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 (http://www.mrexcel.com/archive/Formulas/8960b.html))

kvinay_00
Jul 2, 2009, 11:03 PM
Thank you !