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