Turn Filters On and Off

[Guest]

The below code successfully adds AutoFilters to the selection. How do I
remove the AutoFilters? Tried recording a macro but the code is the same as
for adding filters.

Private Sub CommandButton4_Click()
'Command Button: "Add Filters"
Application.ScreenUpdating = False
Range("B3:I3").Select
Selection.AutoFilter
Application.ScreenUpdating = True
End Sub

 

[Guest]

The same line that turn AutoFilter on is the same command that will turn them
off:

Selection.AutoFilter

 

[Guest]

You can also use

Activesheet.Autofiltermode = False