LinkFormat.AutoUpdate Property (PowerPoint)
Returns or sets the way the link will be updated. Read/write.
Syntax
expression .AutoUpdate
expression A variable that represents an LinkFormat object.
Return Value
PpUpdateOption
Remarks
The value of the AutoUpdate property can be one of these PpUpdateOption constants.
Constant |
Description |
|---|---|
ppUpdateOptionAutomatic |
The link is updated each time the presentation is opened or the source file changes. |
ppUpdateOptionManual |
The link is updated only when the user specifically asks to update the presentation. |
ppUpdateOptionMixed |
Example
This example loops through all the shapes on all the slides in the active presentation and sets all linked Microsoft Excel worksheets to be updated manually.
For Each sld In ActivePresentation.Slides
For Each sh In sld.Shapes
If sh.Type = msoLinkedOLEObject Then
If sh.OLEFormat.ProgID = "Excel.Sheet" Then
sh.LinkFormat.AutoUpdate = ppUpdateOptionManual
End If
End If
Next
Next