OLEObjects Members
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 | |
|---|---|---|
.gif "Public property") |
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. |
|
OnAction | Reserved for internal use. |
|
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. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
_Dummy12 | Reserved for internal use. |
|
_Dummy15 | Reserved for internal use. |
|
_Dummy22 | Reserved for internal use. |
|
_Dummy3 | Reserved for internal use. |
|
_Dummy30 | Reserved for internal use. |
|
_Dummy32 | Reserved for internal use. |
|
_Dummy33 | Reserved for internal use. |
|
_Dummy34 | Reserved for internal use. |
|
_Dummy36 | Reserved for internal use. |
|
_Dummy37 | Reserved for internal use. |
|
_Dummy38 | Reserved for internal use. |
|
_Dummy39 | Reserved for internal use. |
|
_Dummy40 | Reserved for internal use. |
|
_Dummy41 | Reserved for internal use. |
|
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() | (Inherited from IEnumerable.) |
|
GetEnumerator() | |
|
Group | Reserved for internal use. |
|
Item | Returns a single object from a collection. |
|
Select | Selects the object. |
|
SendToBack | Sends the object to the back of the z-order. |
Top