Excel messages

  • Thread starter Thread starter Adhavan
  • Start date Start date
A

Adhavan

How to supress the excel default messages...for example if
my template is a read only and i try to save, it gives a
message like " template is read only choose a different
name to save the template" and shows me Save As box. how
to supress this message so that i cant display my own
message.
 
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
'here your code
End Sub
 
The excel message appears before it start executing the
Workbook_BeforeSave event, when the save button is clicked.
 
Back
Top