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.

Visual Basic for Applications 
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

See also: