Microsoft KB Archive/213569

= XL2000: Menu Added in Wrong Position on Menu Bar =

Article ID: 213569

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213569





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: kbdtacode kbprb kbprogramming KB213569

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.