Unlink Method

Microsoft Excel Visual Basic

Unlink Method

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