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



.