XL98: Toolbars Disappear After Closing Visual Basic Editor (187564)



The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q187564

SYMPTOMS

After you close the Visual Basic Editor in Microsoft Excel 98, all the toolbars disappear except for the worksheet menu bar, which is not functional.

CAUSE

This problem may occur when the following conditions are true:

  • You quit the Visual Basic Editor while a user form is running. -and-

  • You close the user form.
After you close the user form, the toolbars will disappear with the exception of the worksheet menu bar, which will not be functional.

WORKAROUND

To prevent this problem from occurring, use either of the following methods.

Method 1: Don't Run the Visual Basic Editor and a User Form Simultaneously

Always close the Visual Basic Editor before running a user form or close the user form before quitting the Visual Basic Editor.

Method 2: Hide Microsoft Excel

From Microsoft Excel, click Hide Microsoft Excel on the Application menu.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about toolbars, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

toolbars, overview

and then click Show Topics. Select the "About toolbars" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB187564