Edit

CommandBar.Left property (Office)

  • Article

Sets or gets the horizontal distance (in pixels) of the CommandBar from the left edge of the object relative to the screen. Read/write.

Note

The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, see Overview of the Office Fluent ribbon.

Syntax

expression.Left

expression Required. A variable that represents a CommandBar object.

Example

This example moves the command bar named Custom from its docked position along the top of the window to the left edge of the window.

Set myBar = CommandBars("Custom") 
With myBar 
    .Position = 1 
    .RowIndex = 2 
    .Left = 0 
End With

See also

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.