Microsoft Knowledge Base

XL5: Message Box Remains on Screen with Office Manager
Last reviewed: September 12, 1996
Article ID: Q125909
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0

SUMMARY

In Microsoft Excel, if a message box is displayed in a Visual Basic, Applications Edition, macro, the message box may remain on the screen for an extended period of time under the following conditions:

  • The macro takes no physical action following the message box: that is, only calculations are performed in the code following the message box (Select, Activate, or related action methods are not used).

    -and-

  • Microsoft Office Manager is loaded with the "Toolbar Is Always Visible" check box selected.

WORKAROUND

To work around this problem, insert the following line of code above the first message box on the macro sheet: 

   Application.ScreenUpDating = False
With this modification, the message box should disappear in all cases.

MORE INFORMATION

Normally, when you choose a button to exit a message box, the message box disappears immediately while subsequent code runs. If any application that has "always on top" capability, such as Microsoft Office Manager (MOM), is also running, the screen will not be updated to remove the message box until an action item such as Select, Activate, or another MsgBox command is issued.

KBCategory: kbtool kbprg
KBSubcategory:

Additional reference words: 5.00 5.00c MOM



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.