You can use the CommandBars property to return a reference to the CommandBars collection object.
Setting
[application.]CommandBars[.method or property]
The CommandBars property uses the following settings.
Setting | Description |
---|---|
application | Optional. The Application object. |
CommandBars | Required. When used without specifying a method or property, returns the CommandBars collection object. |
method or property | A method or property of the CommandBars collection object. The Item property is the default property for the CommandBars collection object. |
The CommandBars property is available only by using Visual Basic.
Remarks
The CommandBars collection object is the collection of all built-in and custom command bars in an application. You can refer to individual members of the collection by using the member object's index or a string expression that is the name of the member object. The first member object in the collection has an index value of 1 and the total number of member objects in the collection is the value of the CommandBars collection's Count property.
Once you establish a reference to the CommandBars collection object, you can access all the properties and methods of the object. You can set a reference to the CommandBars collection object by clicking References on the Tools menu while in module Design view. Set a reference to the Microsoft Office 9.0 Object Library in the References dialog box by selecting the appropriate check box.