Edit

Share via

Application.CommandBars property (Access)

  • Article

Use the CommandBars property to return a reference to the CommandBars collection object. Read-only CommandBars object.

Syntax

expression.CommandBars

expression A variable that represents an Application object.

Remarks

The CommandBars collection object is the collection of all built-in and custom command bars in an application. 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.

After 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. You can then set a reference to the Microsoft Office 12.0 Object Library in the References dialog box by selecting the appropriate check box.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.