Share via

ListObject.Unlink Method

  • Article
Excel Developer Reference

Removes the link to a Microsoft Windows SharePoint Services site from a list. Returns Nothing.

Syntax

expression.Unlink

expression   A variable that represents a ListObject object.

Remarks

After this method is called and the list is unlinked, it cannot be reversed.

Example

The following example unlinks a list from a SharePoint site.

Visual Basic for Applications 
  Sub UnlinkList()
   Dim wrksht As Worksheet
   Dim objListObj As ListObject
   
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set objListObj = wrksht.ListObjects(1)
      
   objListObj.Unlink
End Sub

See Also