As you have seen, the principal object related to menus and toolbars is the CommandBar object. Menubars, menus, submenus, shortcut menus, and toolbars are CommandBar objects. Note, however, that Office VBA does not treat each of these CommandBar objects in the same way. For instance, the Count property of the CommandBars collection counts only menubars, toolbars and shortcut menus. It does not count menus or submenus. Also, as mentioned earlier, the Add method of the CommandBars collection allows can be used to create toolbars or menubars, but not menus or submenus.
The CommandBar object has a Type property that can assume one of the constants in the following enum:
Enum MsoBarType msoBarTypeNormal = 0 ' toolbar msoBarTypeMenuBar = 1 ' menubar msoBarTypePopup = 2 ' menu, submenu or shortcut menu End Enum
As we have said, one way in which menubars and toolbars differ from menus and submenus is in their creation. To create a new menubar or shortcut menu, we use the Add method of the CommandBars collection. The syntax for the Add method is:
Name, Position, MenuBar, Temporary)
Name parameter is the name of the new command bar. If this argument is omitted, Word VBA assigns a default name (such as “Custom 1”) to the command bar. The optional
Position parameter gives the position of the new command bar. This can be set to
msoBarLeft, msoBarTop, msoBarRight, msoBarBottom,or
msoBarFloating (for a floating ...