Skip to content

Latest commit

 

History

History
51 lines (36 loc) · 1.17 KB

Excel.OLEObject.AutoUpdate.md

File metadata and controls

51 lines (36 loc) · 1.17 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
OLEObject.AutoUpdate property (Excel)
vbaxl10.chm417075
vbaxl10.chm417075
Excel.OLEObject.AutoUpdate
3834c552-a282-ab75-781e-42c055346b7d
05/02/2019
medium

OLEObject.AutoUpdate property (Excel)

True if the OLE object is updated automatically when the source changes. Valid only if the object is linked; its OLEType property must be xlOLELink (XlOLEType enumeration). Read-only Boolean.

Syntax

expression.AutoUpdate

expression A variable that represents an OLEObject object.

Example

This example displays the status of automatic updating for all OLE objects on Sheet1.

Worksheets("Sheet1").Activate 
Range("A1").Value = "Name" 
Range("B1").Value = "Link Status" 
Range("C1").Value = "AutoUpdate Status" 
i = 2 
For Each obj In ActiveSheet.OLEObjects 
 Cells(i, 1) = obj.Name 
 If obj.OLEType = xlOLELink Then 
 Cells(i, 2) = "Linked" 
 Cells(i, 3) = obj.AutoUpdate 
 Else 
 Cells(i, 2) = "Embedded" 
 End If 
 i = i + 1 
Next

[!includeSupport and feedback]