XL97: Microsoft Excel Toolbars Appear in the Visual Basic Editor

• Microsoft Excel 97 for Windows

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.

REFERENCES

For more information about toolbars, click the Index tab in Microsoft Excel 97 Help, type the following text

  toolbars, displaying