Edit

Shape.LinkFormat property (Excel)

  • Article

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

Syntax

expression.LinkFormat

expression A variable that represents a Shape object.

Example

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.