Placement Property
Placement property as it applies to the Shape object.
Returns or sets the way the object is attached to the cells below it. Read/write XlPlacement.
| XlPlacement can be one of these XlPlacement constants. |
| xlFreeFloating |
| xlMove |
| xlMoveAndSize |
expression.Placement
expression Required. An expression that returns one of the above objects.
Returns or sets the way the object is attached to the cells below it. Read/write Variant.
expression.Placement
expression Required. An expression that returns one of the above objects.
Example
This example sets embedded chart one on Sheet1 to be free-floating (it neither moves nor is sized with its underlying cells).
Worksheets("Sheet1").ChartObjects(1).Placement = xlFreeFloating