View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.newusers
Norman Jones
 
Posts: n/a
Default Prevent error messagebox when refresing querytable from the web fails

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