The information in this article applies to:
SYMPTOMSIf 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. CAUSEThe 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.
MORE INFORMATIONThe 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 argumentsbar_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. Additional query words: XL97
Keywords : kbmacro kbprg kbdta xlmhowto xlminfo KbVBA |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |