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

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



.

The excel message appears before it start executing the
Workbook_BeforeSave event, when the save button is clicked.
-----Original Message-----
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.



.

.