Returns True if the AutoFilter drop-down arrows are currently displayed. You can set this property to False to hide the arrows, but you cannot set it to True. Use the AutoFilter method to filter a list and display the drop-down arrows. Read/write Boolean.
expression.AutoFilterMode
expression Required. An expression that returns a Worksheet object.
Remarks
If the AutoFilter drop-down arrows are visible but no rows are currently filtered (all rows are visible), the AutoFilterMode property is True and the FilterMode property is False.
Example
This example turns off the AutoFilter for the active worksheet.
Spreadsheet1.ActiveSheet.AutoFilterMode = False