ListObject.Unlink Method (Excel)
Removes the link to a Microsoft SharePoint Foundation 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.
Sub UnlinkList()
Dim wrksht As Worksheet
Dim objListObj As ListObject
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set objListObj = wrksht.ListObjects(1)
objListObj.Unlink
End Sub