LinkFormat Members

Use the LinkFormat object to update linked OLE objects. Use the Shape object’s LinkFormat property to get a reference to this object. The LinkFormat object has the following members:

Application
AutoUpdate
Creator
Locked
Parent
Update

Make sure the Shape object is a linked object before using the LinkFormat object by testing its Type property as shown here:

If s.Type = msoLinkedOLEObject Then
    s.LinkFormat.Update
End If

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial