Hi Tom,

Using xl2k, the VBA help for DisplayAlerts, says:

'=====================
If you set this property to False, Microsoft Excel doesn't automatically set
it back to True when your macro stops running. Your macro should always set
the property back to True when it stops running.

'=====================

Are you aware when this changed?

---
Regards,
Norman



"Tom Ogilvy" wrote in message
...
In the interests of completeness:

Ken stated:
If this is the solution then make sure it is set back to True before
the code has finished. Excel doesn't reset it itself.

from help on DisplayAlerts:

If you set this property to False, Micorosoft Excel sets this property to
True when the code is finished, unless you are running cross process code.



--

Regards,

Tom Ogilvy



"Ken Johnson" wrote in message
oups.com...
Hi bzm,
Have you tried "Application.DisplayAlerts = False"?

If this is the solution then make sure it is set back to True before
the code has finished. Excel doesn't reset it itself.
Ken Johnson