XL97: ActiveMenuBar.Index Different than Earlier Versions

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you run a Microsoft Visual Basic for Applications macro that contains the following code:

   MsgBox Application.ActiveMenuBar.Index

NOTE: When you run the macro from a Visual Basic module sheet in previous versions of Microsoft Excel, the value -4141 appears in a message box.

CAUSE

This behavior occurs when the following conditions are met:

• You run the macro from a Microsoft Excel 97 worksheet.

      -or-
  

• You run the macro from a module sheet in the Visual Basic Editor.

The value -4167 appears because the Visual Basic Editor is a separate component of Microsoft Excel 97.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

In Microsoft Excel 97, a Visual Basic module sheet is part of the Visual Basic Editor; and the Visual Basic Editor is a separate component of Microsoft Excel. So, when you run the macro from the Visual Basic Editor, the macro returns the value -4167, which indicates that the worksheet menu bar is displayed.

In earlier versions of Microsoft Excel, a Visual Basic for Applications module sheet was part of a Microsoft Excel workbook.

The ActiveMenuBar property returns a CommandBar object that represents the active menu bar in the container application.