Unlink Method [Excel 2003 VBA Language Reference]
Removes the link to a Microsoft Windows SharePoint Services site from a list. Returns Nothing.
expression**.Unlink()**
expression Required. An expression that returns 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
Applies to | ListObject Object