Excel messages
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. |
Excel messages
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. . |
Excel messages
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. . . |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com