Share via

OLEObjects Object Members

  • Article
Excel Developer Reference

A collection of all the OLEObject objects on the specified worksheet.

Methods

  Name Description
Bb242387.methods(en-us,office.12).gif Add Adds a new OLE object to a sheet.
Bb242387.methods(en-us,office.12).gif BringToFront Brings the object to the front of the z-order.
Bb242387.methods(en-us,office.12).gif Copy Copies the object to the Clipboard.
Bb242387.methods(en-us,office.12).gif CopyPicture Copies the selected object to the Clipboard as a picture. Variant.
Bb242387.methods(en-us,office.12).gif Cut Cuts the object to the Clipboard.
Bb242387.methods(en-us,office.12).gif Delete Deletes the object.
Bb242387.methods(en-us,office.12).gif Duplicate Duplicates the object and returns a reference to the new copy.
Bb242387.methods(en-us,office.12).gif Item Returns a single object from a collection.
Bb242387.methods(en-us,office.12).gif Select Selects the object.
Bb242387.methods(en-us,office.12).gif SendToBack Sends the object to the back of the z-order.

Properties

  Name Description
Bb242387.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242387.properties(en-us,office.12).gif AutoLoad True if the OLE object is automatically loaded when the workbook that contains it is opened. Read/write Boolean.
Bb242387.properties(en-us,office.12).gif Border Returns a Border object that represents the border of the object.
Bb242387.properties(en-us,office.12).gif Count Returns a Long value that represents the number of objects in the collection.
Bb242387.properties(en-us,office.12).gif Enabled True if the object is enabled. Read/write Boolean.
Bb242387.properties(en-us,office.12).gif Height Returns or sets a Double value that represents the height, in points, of the object.
Bb242387.properties(en-us,office.12).gif Interior Returns an Interior object that represents the interior of the specified object.
Bb242387.properties(en-us,office.12).gif Left Returns or sets a Double value that represents 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).
Bb242387.properties(en-us,office.12).gif Locked Returns or sets a Boolean value that indicates if the object is locked.
Bb242387.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242387.properties(en-us,office.12).gif Placement Returns or sets a Variant value, containing an XlPlacement constant, that represents the way the object is attached to the cells below it.
Bb242387.properties(en-us,office.12).gif PrintObject True if the object will be printed when the document is printed. Read/write Boolean.
Bb242387.properties(en-us,office.12).gif Shadow Returns or sets a Boolean value that determines if the object has a shadow.
Bb242387.properties(en-us,office.12).gif ShapeRange Returns a ShapeRange object that represents the specified object or objects. Read-only.
Bb242387.properties(en-us,office.12).gif SourceName Returns or sets a String value that represents the specified object's link source name.
Bb242387.properties(en-us,office.12).gif Top Returns or sets a Double value that represents 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).
Bb242387.properties(en-us,office.12).gif Visible Returns or sets a Boolean value that determines whether the object is visible. Read/write.
Bb242387.properties(en-us,office.12).gif Width Returns or sets a Double value that represents the width, in points, of the object.
Bb242387.properties(en-us,office.12).gif ZOrder Returns the z-order position of the object. Read-only Long.