ListObject.Unlist Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Removes the list functionality from a ListObject control.
public:
void Unlist();public void Unlist ();abstract member Unlist : unit -> unitPublic Sub Unlist ()Remarks
This method removes the list functionality from the native Excel Microsoft.Office.Interop.Excel.ListObject object but does not affect the Microsoft.Office.Tools.Excel.ListObject host control; the generated code for the control remains in the project.
After you use this method, the range of cells that made up the list will be a regular range of data.
Running this method leaves the cell data, formatting, and formulas in the worksheet. The Total row is also left intact. This method removes any link to a Microsoft Windows SharePoint Services site. AutoFilter and the Insert row are also removed from the list.