Description
Represents a linked or embedded OLE object on a chart sheet, dialog sheet, or worksheet. You add an OLE object to a sheet by clicking the Object command on the Insert menu or by using the Add method.
Accessors
The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all of the OLE objects on a single sheet. Use the Add method to create a new OLE object and add it to the collection. To access a single member of the collection, use the OLEObjects method with the index number or name of the OLE object as an argument.
The following example deletes OLE object one on the worksheet named "Sheet1."
Worksheets("sheet1").OLEObjects(1).Delete
The OLE object name is shown in the Name Box when the object is selected. Use the Name property to set or return the object name. The following example lines up the left edge of the OLE object named "Picture 8" with the left edge of column B on the worksheet named "Sheet1."
Worksheets("sheet1").OLEObjects("picture 8").Left = _
Worksheets("sheet1").Columns("b").Left
Properties
Application Property, AutoLoad Property, AutoUpdate Property, Border Property, BottomRightCell Property, Creator Property, Enabled Property, Height Property, Index Property, Interior Property, Left Property, Locked Property, Name Property, Object Property, OLEType Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, Shadow Property, Top Property, TopLeftCell Property, Visible Property, Width Property, ZOrder Property.
Methods
Activate Method, BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Select Method, SendToBack Method, Update Method, Verb Method.