|
skip alert msg
how can i run a macro skipping alert msg?
Tks |
What alert message? If it's the security warning you get opening a workbook
having macros in it, that cannot be skipped with code. The user would have to lower his security settings which is not recommended. -- Jim Rech Excel MVP "A" wrote in message ... | how can i run a macro skipping alert msg? | Tks | |
Hi A,
Application.DisplayAlerts = False skips messages like 'Delete sheet. Are you sure?' and performs the [OK] action. It should be in each procedure where needed because it is not a VB setting. Frans "A" wrote in message ... how can i run a macro skipping alert msg? Tks |
Hi A,
Application.DisplayAlerts = False skips messages like 'Delete sheet. Are you sure?' and performs the [OK] action. It should be in each procedure where needed because it is not a VB setting. Frans "A" wrote in message ... how can i run a macro skipping alert msg? Tks |
|
if you do turn alerts off, be sure to turn them back on
again. Alerts were put in as a safty feature. bad idea just to turn them off and leave them off. good in a macro when you know you are going to get an alert and don't want to have to click ok. but always turn alerts back on . Application.DisplayAlerts = False your code Application.DisplayAlerts = True -----Original Message----- Hi A, Application.DisplayAlerts = False skips messages like 'Delete sheet. Are you sure?' and performs the [OK] action. It should be in each procedure where needed because it is not a VB setting. Frans "A" wrote in message ... how can i run a macro skipping alert msg? Tks . |
|
if you do turn alerts off, be sure to turn them back on
again. Alerts were put in as a safty feature. bad idea just to turn them off and leave them off. good in a macro when you know you are going to get an alert and don't want to have to click ok. but always turn alerts back on . Application.DisplayAlerts = False your code Application.DisplayAlerts = True -----Original Message----- Hi A, Application.DisplayAlerts = False skips messages like 'Delete sheet. Are you sure?' and performs the [OK] action. It should be in each procedure where needed because it is not a VB setting. Frans "A" wrote in message ... how can i run a macro skipping alert msg? Tks . |
Hi Anonymous,
As far as I know, Application.DisplayAlerts is ON by default for every new procedure that you run. Even if some other procedure has set it OFF. Called procedures inherit the setting of the parent. The same goes for Application.ScreenUpdating = False but *not* for Application.EnableEvents = False. Frans wrote in message ... if you do turn alerts off, be sure to turn them back on again. Alerts were put in as a safty feature. bad idea just to turn them off and leave them off. good in a macro when you know you are going to get an alert and don't want to have to click ok. but always turn alerts back on . Application.DisplayAlerts = False your code Application.DisplayAlerts = True -----Original Message----- Hi A, Application.DisplayAlerts = False skips messages like 'Delete sheet. Are you sure?' and performs the [OK] action. It should be in each procedure where needed because it is not a VB setting. Frans "A" wrote in message ... how can i run a macro skipping alert msg? Tks . |
Thank you very much!
It works! A "Frans van Zelm" escreveu: Hi Anonymous, As far as I know, Application.DisplayAlerts is ON by default for every new procedure that you run. Even if some other procedure has set it OFF. Called procedures inherit the setting of the parent. The same goes for Application.ScreenUpdating = False but *not* for Application.EnableEvents = False. Frans wrote in message ... if you do turn alerts off, be sure to turn them back on again. Alerts were put in as a safty feature. bad idea just to turn them off and leave them off. good in a macro when you know you are going to get an alert and don't want to have to click ok. but always turn alerts back on . Application.DisplayAlerts = False your code Application.DisplayAlerts = True -----Original Message----- Hi A, Application.DisplayAlerts = False skips messages like 'Delete sheet. Are you sure?' and performs the [OK] action. It should be in each procedure where needed because it is not a VB setting. Frans "A" wrote in message ... how can i run a macro skipping alert msg? Tks . |
| All times are GMT +1. The time now is 09:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com