XL97: Change in ADD.MENU Macro Position Argument (157347)

The information in this article applies to:

Microsoft Excel 97 for Windows

This article was previously published under Q157347

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 from the location in earlier versions of Microsoft Excel.

CAUSE

The XLM ADD.MENU macro function has an optional third argument called Position. If you do not specify anything for the Position argument in Microsoft Excel versions 4.0, 5.0, and 7.0, the ADD.MENU function adds your custom menu to the left of the Help menu. If you do not specify anything for the Position argument in Microsoft Excel 97, 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.

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")

MORE INFORMATION

The ADD.MENU macro function has the following syntax:

=ADD.MENU(bar_num, menu_ref, Position)

NOTE: The first two arguments are required.

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 areadded to the left of the menu specified with the Position argument.

Modification Type:	Major	Last Reviewed:	10/21/2000
Keywords:	kbmacro kbProgramming KB157347