Partager via

OLEObjects Members

  • Article

Include Protected Members
Include Inherited 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 OLEObjects type exposes the following members.

Properties

  Name Description
Public property Application Returns an Application object that represents the Microsoft Excel application.
Public property AutoLoad True if the OLE object is automatically loaded when the workbook that contains it is opened.
Public property Border Returns a Border object that represents the border of the object.
Public property Count Returns the number of objects in the collection.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created.
Public property Enabled True if the object is enabled.
Public property Height The height, in points, of the object.
Public property Interior Returns an Interior object that represents the interior of the specified object.
Public property 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).
Public property Locked True if the object is locked; False if the object can be modified when the sheet is protected.
Public property OnAction Reserved for internal use.
Public property Parent Returns the parent object for the specified object.
Public property Placement Returns or sets the way the object is attached to the cells below it.
Public property PrintObject True if the object will be printed when the document is printed.
Public property Shadow True if the font is a shadow font or if the object has a shadow.
Public property ShapeRange Returns a ShapeRange object that represents the specified object or objects.
Public property SourceName Returns or sets the specified object's link source name.
Public property 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).
Public property Visible Determines whether the object is visible.
Public property Width The width, in points, of the object.
Public property ZOrder Returns the z-order position of the object.

Top

Methods

  Name Description
Public method _Dummy12 Reserved for internal use.
Public method _Dummy15 Reserved for internal use.
Public method _Dummy22 Reserved for internal use.
Public method _Dummy3 Reserved for internal use.
Public method _Dummy30 Reserved for internal use.
Public method _Dummy32 Reserved for internal use.
Public method _Dummy33 Reserved for internal use.
Public method _Dummy34 Reserved for internal use.
Public method _Dummy36 Reserved for internal use.
Public method _Dummy37 Reserved for internal use.
Public method _Dummy38 Reserved for internal use.
Public method _Dummy39 Reserved for internal use.
Public method _Dummy40 Reserved for internal use.
Public method _Dummy41 Reserved for internal use.
Public method Add Adds a new OLE object to a sheet. Returns an OLEObject object.
Public method BringToFront Brings the object to the front of the z-order.
Public method Copy Copies the object to the Clipboard.
Public method CopyPicture Copies the selected object to the Clipboard as a picture.
Public method Cut Cuts the object to the Clipboard or pastes it into a specified destination.
Public method Delete Deletes the object.
Public method Duplicate Duplicates the object and returns a reference to the new copy.
Public method GetEnumerator() (Inherited from IEnumerable.)
Public method GetEnumerator()
Public method Group Reserved for internal use.
Public method Item Returns a single object from a collection.
Public method Select Selects the object.
Public method SendToBack Sends the object to the back of the z-order.

Top

See Also

Reference

OLEObjects Interface

Microsoft.Office.Interop.Excel Namespace