Master Filter Sheet to Filter All Sheets

Originally Posted by nguyeda

How can I get the "Clear All Filters" button to clear out the criteria but not the filters completly?

Did you get this OK? If not, here would be change to make: In the "Sub AutoFilter_AllSheets" macro change

If Len(Crit1) = 0 Then .ListObjects(1).Range.AutoFilter

to the following ...

If Len(Crit1) = 0 Then .ListObjects(1).Range.AutoFilter Field:=1, Criteria1:=Null