LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent error messagebox when refresing querytable from the web fails bzm Excel Discussion (Misc queries) 16 January 17th 06 03:32 PM
Prevent error messagebox when refresing querytable from the web fails bzm New Users to Excel 13 January 17th 06 01:24 PM


All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"