共用方式為


ListObject.ShowAutoFilter Property (Excel)

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

Syntax

expression .ShowAutoFilter

expression A variable that represents 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

請參閱

概念

ListObject Object

ListObject Object Members