Microsoft KB Archive/162549

= XL97: Microsoft Excel Toolbars Appear in the Visual Basic Editor =

Article ID: 162549

Article Last Modified on 10/21/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q162549



SYMPTOMS
Microsoft Excel toolbars may appear in the Microsoft Visual Basic Editor.



CAUSE
This behavior occurs when the toolbar is undocked and you switch to the Microsoft Visual Basic Editor. This behavior also occurs when you run a subroutine that activates the toolbar by creating an object that has an associated toolbar (for example, a chart).



WORKAROUND
If you do not want the toolbar to appear in the Microsoft Visual Basic Editor, use one of the following methods.

Method 1
Close the toolbar by clicking the Close button (the "X") in the upper-right corner of the toolbar. By doing this, you switch back to Microsoft Excel. Press ALT+F11 to return to the Microsoft Visual Basic Editor.

Note: Closing the toolbar in this manner may cause the toolbar to disappear when you switch back to Microsoft Excel. To view the toolbar in Microsoft Excel, click Toolbars on the View menu, and then select the toolbar you want to use.

Method 2
Switch to Microsoft Excel by pressing ALT+Q, and then deactivate the object the toolbar is associated with to close the toolbar.

For example, if a chart is active, the Chart toolbar is displayed. Click any cell to close the chart and close the Chart toolbar.

Method 3
Switch to Microsoft Excel by pressing ALT+Q. Dock the toolbar by dragging it by the title bar and placing it at one side of the window.

Method 4
If a toolbar is displayed when you run a subroutine, deactivate the object that is associated with that toolbar.

For example, if a chart is created through macro code, deactivate the chart with macro code by selecting another object, such as a cell.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

