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



.