Microsoft KB Archive/152758

= Object Browser not Available Until Module Sheet Is Loaded =

Article ID: 152758

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q152758



SYMPTOMS
When you try to bring up the Microsoft Excel Object Browser using the Object Browser toolbar button on the Visual Basic toolbar, the Object Browser may not be displayed.



CAUSE
The Object Browser will not be displayed if no Visual Basic module sheets have been opened during that session of Microsoft Excel.



RESOLUTION
When you open a Microsoft Excel workbook that has a module sheet or if you add a module sheet to a workbook, Visual Basic for Applications is initialized and the Object Browser will then be available. If you do not have a module sheet in any open workbooks, on the Insert menu, point to Macro, and then click Module.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



MORE INFORMATION
In Microsoft Excel version 5.0, a module sheet must be the active sheet in the active workbook in order to view the Object Browser. In Microsoft Excel version 7.0, a module sheet does not have to be the active sheet in order to view the Object Browser, but you must have at least one module sheet in any of your open workbooks.

