CommandBar and CommandBars Members

Use the CommandBars collection to add new menus and toolbars to Excel or to get existing menus or toolbars. Use the Application object’s CommandBars property to get a reference to this collection. Use the CommandBar object to add controls to the menu or toolbar or to get existing controls to modify. The CommandBars collection and CommandBar object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

ActionControl 1

ActiveMenuBar

AdaptiveMenus 2

Add 1

Application 2

BuiltIn

Context

Controls

Count 1

Creator 2

Delete

DisableAskAQuestionDropdown 1

DisableCustomize

DisplayFonts

DisplayKeysInTooltips

DisplayTooltips 1

Enabled

FindControl 2

FindControls 1

Height

Id

Index

Item 1

LargeButtons 1

Left

MenuAnimationStyle 1

Name

NameLocal

Parent 2

Position

Protection

ReleaseFocus 1

Reset

RowIndex

ShowPopup

Top

Type

Visible

Width

 

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.