Shape.LinkFormat Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a LinkFormat object that contains linked OLE object properties. Read-only.

expression .LinkFormat

expression A variable that represents a Shape object.

This example updates all linked OLE objects on worksheet one.

For Each s In Worksheets(1).Shapes 
 If s.Type = msoLinkedOLEObject Then s.LinkFormat.Update 
Next

Concepts

Other resources

Show: