XL97: Menubars and Toolbars Flash When You Close a Workbook

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you close a workbook, all of your menubars and toolbars may flash (they disappear and then quickly reappear) when you close a workbook.

CAUSE

This will occur if you used the Menu Editor in either Microsoft Excel version 5.0 or 7.0 to add custom menu items to the workbook.

RESOLUTION

Even though your menubars and toolbars disappear and then reappear when such a workbook is closed, custom menu items and custom toolbar buttons created by macros in Microsoft Excel 97 should not be affected.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

Because of the way in which Microsoft Excel 97 works with custom menu items, when you close a workbook that contains custom menu items created by the Menu Editor in Microsoft Excel version 5.0 or 7.0, Microsoft Excel 97 redraws all of your visible menubars and toolbars.

This is purely a visual effect: no custom menu items or custom toolbar buttons are lost from your menus when this happens. However, there is no way to suppress the flashing of the menubars and toolbars. Using

   Application.ScreenUpdating = False

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q157087
   TITLE     : XL97: Cannot Modify or Delete Custom Menus