Show AllSome of the content in this topic may not be applicable to some languages.
Left property as it applies to the Assistant and CommandBar objects.
Sets or returns the horizontal position of the Office Assistant window (in points), or the distance (in pixels) of the command bar, from the left edge of the specified object relative to the screen. Read/write Long.
expression.Left
expression Required. An expression that returns one of the above objects.
Set or returns the horizontal position of the specified command bar control (in pixels) relative to the left edge of the screen. Returns the distance from the left side of the docking area. Read-only Long.
expression.Left
expression Required. An expression that returns one of the above objects.
As it applies to the Assistant and CommandBar objects.
This example displays the Office Assistant and moves it to the specified position within the application window.
With Assistant
.Visible = True
.Left = 300
.Top = 300
End With
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