Microsoft KB Archive/157611

= XL97: Menu Bars and Toolbars Flash When You Close a Workbook =

Article ID: 157611

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q157611



SYMPTOMS
In Microsoft Excel 97, when you close a workbook, all of your menu bars 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.

This behavior is by design of Microsoft Excel.



RESOLUTION
Even though your menu bars 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.



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 menu bars 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 menu bars and toolbars. Using Application.ScreenUpdating = False to try to suppress the flashing of menu bars and toolbars will not work.

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

157087 XL97: Cannot Modify or Delete Custom Menus

Additional query words: XL97 menu bars commandbars command flashes blink flicker redraw

Keywords: kbprb KB157611

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.