XL97: Change in ADD.MENU Macro Position Argument

• Microsoft Excel 97 for Windows

SYMPTOMS

If you run a Microsoft Excel version 4.0 (XLM) macro that contains the ADD.MENU macro function, the location of the menu you add may be different than in earlier versions of Microsoft Excel.

CAUSE

The XLM ADD.MENU macro function has an optional third argument called Position. In Microsoft Excel versions 4.0, 5.0 and 7.0, if you do not specify anything for the Position argument, the ADD.MENU function adds your custom menu to the left of the Help menu. In Microsoft Excel 97, if you do not use the Position argument, the function adds your custom menu to the right of the Help menu.

RESOLUTION

If you want your custom menu to appear immediately to the left of the Help menu in Microsoft Excel 97, you must specify something for the Position argument. For example, if you have your Menu definition table in a defined name called "Testmenu" and you want your custom menu to appear on the Worksheet menu bar, use the following macro command:

   =ADD.MENU(10,Testmenu,"Help")

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

The ADD.MENU macro function has the following syntax:

   =ADD.MENU(bar_num, menu_ref, Position)

Descriptions of the ADD.MENU arguments

bar_num: the ID number for the menu bar to which you want your menu added.

menu_ref: the reference on your Macro sheet for your Menu definition table.

Position: a name (as text) or number of an existing menu. Custom menus are

          added to the left of the menu specified with the Position
          argument.