OLEObjects OLEObjects OLEObjects Interface
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.
public interface class OLEObjects : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("000208A3-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface OLEObjects : System.Collections.IEnumerable
Public Interface OLEObjects Implements IEnumerable
Use the OLEObjects(Object) method to return the OLEObjects collection.
Use the Add(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) method to create a new OLE object and add it to the OLEObjects collection.
An ActiveX control on a sheet has two names: the name of the shape that contains the control, which you can see in the Name box when you view the sheet, and the code name for the control, which you can see in the cell to the right of (Name) in the Properties window. When you first add a control to a sheet, the shape name and code name match. However, if you change either the shape name or code name, the other is not automatically changed to match.
You use the code name of a control in the names of its event procedures. However, when you return a control from the Shapes or OLEObjects collection for a sheet, you must use the shape name, not the code name, to refer to the control by name. For example, assume that you add a check box to a sheet and that both the default shape name and the default code name are CheckBox1. If you then change the control code name by typing chkFinished next to (Name) in the Properties window, you must use chkFinished in event procedures names, but you still have to use CheckBox1 to return the control from the Shapes or OLEObjects collection.
|Application Application Application||
Returns an Application object that represents the Microsoft Excel application.
|AutoLoad AutoLoad AutoLoad||
True if the OLE object is automatically loaded when the workbook that contains it is opened.
|Border Border Border||
Returns a Border object that represents the border of the object.
|Count Count Count||
Returns the number of objects in the collection.
|Creator Creator Creator||
Returns a 32-bit integer that indicates the application in which this object was created.
|Enabled Enabled Enabled||
True if the object is enabled.
|Height Height Height||
The height, in points, of the object.
|Interior Interior Interior||
Returns an Interior object that represents the interior of the specified object.
|Left Left 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 Locked Locked||
True if the object is locked; False if the object can be modified when the sheet is protected.
|OnAction OnAction OnAction||
Reserved for internal use.
|Parent Parent Parent||
Returns the parent object for the specified object.
|Placement Placement Placement||
Returns or sets the way the object is attached to the cells below it.
|PrintObject PrintObject PrintObject||
True if the object will be printed when the document is printed.
|Shadow Shadow Shadow||
True if the font is a shadow font or if the object has a shadow.
|ShapeRange ShapeRange ShapeRange||
Returns a ShapeRange object that represents the specified object or objects.
|SourceName SourceName SourceName||
Returns or sets the specified object's link source name.
|Top Top 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 Visible Visible||
Determines whether the object is visible.
|Width Width Width||
The width, in points, of the object.
|ZOrder ZOrder ZOrder||
Returns the z-order position of the object.