Gets or sets the width (in pixels) of the specified command bar. Read/write.

Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Syntax

expression.Width

expression A variable that represents a CommandBar object.

Return Value
Integer

Example
This example adds a custom control to the command bar named Custom. The example sets the height of the custom control to twice the height of the command bar and sets its width to 50 pixels. Notice how the command bar automatically resizes itself to accommodate the control.

Visual Basic for Applications 
Set myBar = CommandBars("Custom") barHeight = myBar.Height Set myControl = myBar.Controls _ .Add(Type:=msoControlButton, _ Id:= CommandBars("Standard").Controls("Save").Id, _ Temporary:=True) With myControl .Height = barHeight * 2 .Width = 50 End With myBar.Visible = True

See also: