ShowAutoFilter Property

Returns Boolean to indicate whether the AutoFilter will be displayed. Read/write Boolean.

expression.ShowAutoFilter

expression    Required. An expression that returns a ListObject object.

Remarks

ShowAutoFilter property defaults to True for a new ListObject object.

Example

The following example displays the setting of the ShowAutoFilter property the default list in Sheet 1 of the active workbook.

       
   Dim wrksht As Worksheet
   Dim oListCol As ListColumn
   
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set oListCol = wrksht.ListObjects(1)

   Debug.Print oListCol.ShowAutoFilter