skip alert msg

[Guest]

how can i run a macro skipping alert msg?
Tks

 

[Jim Rech]

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
| how can i run a macro skipping alert msg?
| Tks
|

 

[Frans van Zelm]

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

 

[Guest]

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

how can i run a macro skipping alert msg?
Tks

.

 

[Guest]

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

how can i run a macro skipping alert msg?
Tks

.

 

[Frans van Zelm]

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

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

how can i run a macro skipping alert msg?
Tks

.

 

[Guest]

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

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

how can i run a macro skipping alert msg?
Tks



.