Skip to content

Latest commit

 

History

History
44 lines (25 loc) · 1.28 KB

Excel.OLEObject.AutoLoad.md

File metadata and controls

44 lines (25 loc) · 1.28 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
OLEObject.AutoLoad property (Excel)
vbaxl10.chm417074
vbaxl10.chm417074
Excel.OLEObject.AutoLoad
cf57d137-8b26-5f19-29a0-13e350cfd32a
05/02/2019
medium

OLEObject.AutoLoad property (Excel)

True if the OLE object is automatically loaded when the workbook that contains it is opened. Read/write Boolean.

Syntax

expression.AutoLoad

expression A variable that represents an OLEObject object.

Remarks

This property is ignored by ActiveX controls. ActiveX controls are always loaded when a workbook is opened.

For most OLE object types, this property shouldn't 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 on the active sheet.

ActiveSheet.OLEObjects(1).AutoLoad = False

[!includeSupport and feedback]