Hi, I want to disable all save option's in a workbook but still allow 2 macros to save the file.
Im using this to disable the save option:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = False Then
Cancel = True
MsgBox "You cannot save this workbook. Use Save As"
End If
End Sub
The macros I use to save the book are called Macro1 and Macro2
Kind Regards,
Dan.
Im using this to disable the save option:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = False Then
Cancel = True
MsgBox "You cannot save this workbook. Use Save As"
End If
End Sub
The macros I use to save the book are called Macro1 and Macro2
Kind Regards,
Dan.