Applies To
Arc Object, Arcs Collection, Button Object, Buttons Collection, ChartObject Object, ChartObjects Collection, CheckBox Object, Drawing Object, DrawingObjects Collection, Drawings Collection, DropDown Object, DropDowns Collection, EditBox Object, EditBoxes Collection, GroupBox Object, GroupBoxes Collection, GroupObject Object, GroupObjects Collection, Label Object, Labels Collection, Line Object, Lines Collection, ListBox Object, ListBoxes Collection, OLEObject Object, OLEObjects Collection, OptionButton Object, OptionButtons Collection, Oval Object, Ovals Collection, Picture Object, Pictures Collection, Rectangle Object, Rectangles Collection, ScrollBar Object, ScrollBars Collection, Spinner Object, Spinners Collection, TextBox Object, TextBoxes Collection.
Description
Returns or sets how the object is attached to the cells below it. Can be one of xlMoveAndSize, xlMove, or xlFreeFloating. Can be used only on objects in a worksheet. Read-write.
Example
This example sets oval one on Sheet1 to be free floating (it neither moves nor is sized with its underlying cells).
Worksheets("Sheet1").Ovals(1).Placement = xlFreeFloating