Placement Property [Excel 2003 VBA Language Reference]
Placement property as it applies to the Shape object.
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.
Placement 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.
| Use one of the following constants |
| xlFreeFloating |
| xlMove |
| xlMoveAndSize |
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
Applies to | ChartObject Object | ChartObjects Collection Object | OLEObject Object | OLEObjects Collection Object | Shape Object