Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
'here your code
End Sub

-----Original Message-----
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.



.