Home |
Search |
Today's Posts |
#11
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent error messagebox when refresing querytable from the web fails | Excel Discussion (Misc queries) | |||
Prevent error messagebox when refresing querytable from the web fails | New Users to Excel |