Edit

Share via

Workbook.CommandBars property (Excel)

  • Article

Returns a CommandBars object that represents the Microsoft Excel command bars. Read-only.

Syntax

expression.CommandBars

expression An expression that returns a Workbook object.

Remarks

Used with the Application object, this property returns the set of built-in and custom command bars available to the application.

When a workbook is embedded in another application and activated by the user by double-clicking the workbook, using this property with a Workbook object returns the set of Microsoft Excel command bars available within the other application. At all other times, using this property with a Workbook object returns Nothing.

There is no programmatic way to return the set of command bars attached to a workbook.

Example

This example deletes all custom command bars that aren't visible.

For Each bar In Application.CommandBars 
    If Not bar.BuiltIn And Not bar.Visible Then bar.Delete 
Next

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.