Thoughtful reflection on this article:
http://support.microsoft.com/kb/153043/en-us

would suggest to me that the behavior to reset to true has not changed and
that the help in xl2k is incorrect. I use xl97 extensively and don't ever
recall that displayalerts remained false after code terminated. Admittedly
I don't recall ever testing this explicitly, but believe I would have
noticed. Do you have a different experience?

--
Regards,
Tom Ogilvy

"Norman Jones" wrote in message
...
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