LinkFormat Object

Remarks

The OLEFormat object contains properties and methods that apply to OLE objects whether or not they're linked. The PictureFormat object contains properties and methods that apply to pictures and OLE objects.

Example

Use the LinkFormat property to return a LinkFormat object. The following 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

See also:

• Microsoft PowerPoint Object Model Overview
• LinkFormat Object Members