Hide ALL dropdowns on autofilter
After the code below. I want to hide all the dropdown auto filter arrows on
each column, but I want the filter I applied to stay???
Private Sub Band3_Click()
AutoFilterMode = False
Worksheets("Tracker").Range("A2").AutoFilter Field:=3, Criteria1:="Band 3"
Worksheets("Tracker").Range("A2").AutoFilter Field:=12, Criteria1:="="
'AutoFilterMode = False
End Sub
|