Toggling one column of AutoFiltering

M

Mike Niemotka

I have a macro that sets different columns criteria for Autofiltering,
and I have buttons set up on the button bar to activate each macro.

What I would like to do is change the code so that each time I click
the button, that paricular criteria would either be turned on or off,
depending on it's current value. I have included a sample of one of
the macros below.

Sub Add_GreenZone()
'filter for the GREEN zone
If Not ActiveSheet.AutoFilterMode Then ' turn on autofilter if it
is off
ActiveSheet.Range("a1").AutoFilter
End If
Selection.AutoFilter Field:=8, Criteria1:="Green" ' set the
criteria
End Sub

So I think what I need it the ability to see if a particular column
has a filter applied.

Any help would be appreciated.

Mike
 
Top