Placement Property

Applies To

ChartObject object, ChartObjects collection object, OLEObject object, OLEObjects collection object, Shape object.

Description

Returns or sets the way the object is attached to the cells below it. Can be one of the following XlPlacement constants: xlMoveAndSize, xlMove, or xlFreeFloating. Can be used only on objects on a worksheet. Read/write Long.

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