ListObject.Unlink Method

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`

unlink unlink list unlink method

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