View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kenny kenny is offline
external usenet poster
 
Posts: 90
Default 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