This documentation is archived and is not being maintained.

OLEObjects Members 

A collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.

The following tables list the members exposed by the OLEObjects type.

  Name Description
Application Returns an Application object that represents the Microsoft Excel application.
AutoLoad True if the OLE object is automatically loaded when the workbook that contains it is opened.
Border Returns a Border object that represents the border of the object.
Count Returns the number of objects in the collection.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
Enabled True if the object is enabled.
Height The height, in points, of the object.
Interior Returns an Interior object that represents the interior of the specified object.
Left The distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
Locked True if the object is locked; False if the object can be modified when the sheet is protected.
Parent Returns the parent object for the specified object.
Placement Returns or sets the way the object is attached to the cells below it.
PrintObject True if the object will be printed when the document is printed.
Shadow True if the font is a shadow font or if the object has a shadow.
ShapeRange Returns a ShapeRange object that represents the specified object or objects.
SourceName Returns or sets the specified object's link source name.
Top The distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
Visible Determines whether the object is visible.
Width The width, in points, of the object.
ZOrder Returns the z-order position of the object.

  Name Description
Add Adds a new OLE object to a sheet. Returns an OLEObject object.
BringToFront Brings the object to the front of the z-order.
Copy Copies the object to the Clipboard.
CopyPicture Copies the selected object to the Clipboard as a picture.
Cut Cuts the object to the Clipboard or pastes it into a specified destination.
Delete Deletes the object.
Duplicate Duplicates the object and returns a reference to the new copy.
GetEnumerator Returns an enumerator to support iterating through the collection.
Item Returns a single object from a collection.
Select Selects the object.
SendToBack Sends the object to the back of the z-order.