Placement Property

Microsoft Excel Visual Basic

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.

ShowPlacement property as it applies to the ChartObject, ChartObjects, OLEObject, and OLEObjects 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