Hi Tom,
Thank you for youe reply.
Simple testing confirms your original assertion.
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?
No, I do not.
I checked VBA help in this instance, simply because I could not recall
having ever seen your quoted statement. I was, therefore surprised to
encounter the apparent discepancy.
FWIW, although I have always believed that the setting was not persistent, I
have invariably reset DisplayAlerts to true at the end of the macro: I guess
that is something which I could often drop in future.
Thank you for the link and information.
---
Regards,
Norman
"Tom Ogilvy" wrote in message
...
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