O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

 

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required