Master Filter Sheet to Filter All Sheets

mtm70, Sorry, I can't help you much. Too busy. The old code was intended for Excel2003. You want it to work for Excel2007/10. The problem is that Excel2003 only had 6 "operators" and Excel2007/10 has 11 "operators" and can accommodate arrays for the criterias. Try recording a macro where you select 3 check box options from the filter drop down, and you will see how criteria1 is an array and the operator = xlFilterValues (7). The code needs to be adjusted for these new options. Hope you can take it from here or solicit someone else to help. Sorry, just can't help at this time.

No problem!

That's a brilliant idea thought. I will let you know if it works. I really appreciate you getting back to me

mtm70, Modified & attached altered worksheet that (I think) will work for you. The lines numbered 101-103 & 110 are the altered lines. The fix involved dealing with the expanded version of 'operator' and using [IsEmpty()] instead of [= ""] to work with arrays for the "Criteria1" variable. Holler back if this doesn't work for you. sauerj
FilterSheets(2012-12-15).xls

Wow - that is perfect!

Thanks again for your help, you've made my day!