CommandBar Object
Office Developer Reference |
Represents a command bar in the container application. The CommandBar object is a member of the CommandBars collection.
Note |
---|
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon." |
Example
Use CommandBars(
index
), where
index
is the name or index number of a command bar, to return a single CommandBar object. The following example steps through the collection of command bars to find the command bar named "Forms." If it finds this command bar, the example makes it visible and protects its docking state. In this example, the variable cb represents a CommandBar object.
Visual Basic for Applications |
---|
|
You can use a name or index number to specify a menu bar or toolbar in the list of available menu bars and toolbars in the container application. However, you must use a name to specify a menu, shortcut menu, or submenu (all of which are represented by CommandBar objects). This example adds a new menu item to the bottom of the Tools menu. When clicked, the new menu item runs the procedure named "qtrReport."
Visual Basic for Applications |
---|
|
If two or more custom menus or submenus have the same name, CommandBars(index) returns the first one. To ensure that you return the correct menu or submenu, locate the pop-up control that displays that menu. Then apply the CommandBar property to the pop-up control to return the command bar that represents that menu. Assuming that the third control on the toolbar named "Custom Tools" is a pop-up control, this example adds the Save command to the bottom of that menu.
Visual Basic for Applications |
---|
|
See Also
- Object Model Reference
- CommandBar Object Members
- How to: Add a New Navigation Group and Move a Folder into that Group
- How to: Customize a Context Menu to Support Moving Items between Calendars
- How to: Enumerate, Show, Hide, and Position Modules in the Navigation Pane
- How to: Hide or Disable a Menu Item on a Context Menu
- How to: Share Contact Information Including the Business Card