Microsoft KB Archive/125909

= 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.