Class LinkFormat (Excel VBA)

Contains linked OLE object properties.

AutoUpdate

True if the LinkFormat object is updated automatically when the source changes.

Dim lft As LinkFormat: Set lft = 
lft.AutoUpdate = True

Locked

Returns or sets a Boolean value that indicates if the object is locked.

This property returns True if the object is locked or False if the object can be modified when the sheet is protected.

Dim lft As LinkFormat: Set lft = 
lft.Locked = True

Update

Updates the link.

Dim lft As LinkFormat: Set lft = 
lft.Update