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



.