CommandBar.Left property (Office)
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.