AutoLoad Property

Applies To

OLEObject Object.

Description

True if the OLE object is automatically loaded when the workbook that contains the object is opened. This property is available only in Microsoft Excel for Windows 95. Read-write.

Remarks

For most OLE object types, this property should not be set to True. By default, the AutoLoad property is set to False for new OLE objects; this saves time and memory when Microsoft Excel is loading workbooks. The benefit of automatically loading OLE objects is that, for objects that represent volatile data, links to source data can be reestablished immediately and the objects can be rendered again, if necessary.

Example

This example sets the AutoLoad property for OLE object one.


ActiveSheet.OLEObjects(1).AutoLoad = True