Article ID: 212541 - Last Review: July 13, 2007 - Revision: 3.3

WD2000: How to Add a Drop-down Menu to the Main Menu Bar

View products that this article applies to.

This article was previously published under Q212541

SUMMARY

This article describes how to add a drop-down menu to the menu bar that appears even when no documents are open.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
For more information about how to use the sample code in this article, click the article number below to view the article in the Microsoft Knowledge Base:

212536 (http://support.microsoft.com/kb/212536/EN-US/ ) OFF2000: How to Run Sample Code from Knowledge Base Articles

NOTE: For this macro to run, you must have the Microsoft Office 9.0 Object Library reference added in. To do this, follow these steps:

On the Tools menu in Word, point to Macro and click Visual Basic Editor.
In the Visual Basic Editor, click References on the Tools menu.
Under Available References, click to select Microsoft Office 9.0 Object Library, and then click OK.

The following sample Visual Basic for Applications macro adds a custom menu item (New Menu) to the main menu bar (Menu Bar), and then adds a submenu drop-down (Sub Menu) to the New Menu item.

Sub AddMenuItem()

   Dim oMainMenuBar As Object
   Dim oNewMenu As Object
   Dim oSubMenu As Object

   ' Save changes to menu bars in the Normal (default) Template.
   CustomizationContext = Application.NormalTemplate

   ' Specify the CommandBar to add to. In this example, the New Menu
   ' item is added to the Word for Windows default menu bar.
   Set oMainMenuBar = CommandBars.Item("Menu Bar")

   ' Create New Menu object and add it to the built-in Menu Bar.
   Set oNewMenu = oMainMenuBar.Controls.Add(Type:=msoControlPopup)
   oNewMenu.Caption = "New Menu Item"

   ' Create a submenu item for the New Menu menu item.
   Set oSubMenu = oNewMenu.Controls.Add(Type:=msoBarTypeMenuBar)

   With oSubMenu
      ' Give the submenu item a reference name and display text.
      .Caption = "Sub Menu"
      ' Specify macro to run when user clicks the submenu item.
      .OnAction = "NewMenuMacro"
   End With

End Sub

The following sample macro runs when the user clicks the submenu item Sub Menu.

Sub NewMenuMacro()

   Dim myMenuItem as Object

   Set myMenuItem = CommandBars("Menu Bar").Controls("New Menu Item")
   MsgBox myMenuItem.Caption

End Sub

For more information about customizing command bars, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type command bars in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For additional information about how to remove a submenu, click the article number below to view the article in the Microsoft Knowledge Base:

212629 (http://support.microsoft.com/kb/212629/EN-US/ ) WD2000: Sample Macro to Remove a Submenu from a Menu

Back to the top

REFERENCES

For additional information about getting help with Visual Basic for Applications, click the article numbers below to view the articles in the Microsoft Knowledge Base:

212623 (http://support.microsoft.com/kb/212623/EN-US/ ) WD2000: Macro Programming Resources

226118 (http://support.microsoft.com/kb/226118/EN-US/ ) OFF2000: Programming Resources for Visual Basic for Applications

Back to the top