XL2000: Menu Added in Wrong Position on Menu Bar

ID: Q213569

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you run a Visual Basic for Applications macro that adds a new menu to a menu bar, the new menu appears to the right of the Help menu, rather than to the left of it.

CAUSE

This behavior occurs because, in Microsoft Excel 2000, the Help menu does not have any special status. In versions of Microsoft Excel earlier than Excel 97, you cannot create new menus to the right of the Help menu.

WORKAROUND

If you need to create a custom menu to the left of the Help menu, add the "Before:=" argument to the line of code that creates the new menu, for example:


MenuBars(xlWorksheet).Menus.Add Caption:="Custom", Before:="Help"

You can use any valid menu name in the Before argument. The new menu will appear to the left of the specified menu name.

MORE INFORMATION

In versions of Excel earlier than Excel 97, if you use a macro to create a custom menu and do not specify the menu bar position where the new menu should appear, the new menu always appears to the left of the Help menu. For example, if you execute this line of Visual Basic macro code


MenuBars(xlWorksheet).Menus.Add Caption:="Custom"

the new Custom menu will appear to the left of the Help menu.

This behavior occurs because the Help menu has special status in earlier versions of Microsoft Excel: the Help menu is always the rightmost menu on a menu bar.

In Microsoft Excel 2000, the Help menu has no special status. Because of this, Excel always adds new menus to the right of the Help menu.

If your custom menu needs to appear to the left of the Help menu, use the workaround shown earlier in this article to create the custom menu.

Additional query words: commandbar command bar XL2000

Keywords : kbprg kbdta kbdtacode OffVBA KbVBA xlvbmigrate
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb