i'm using Excel 2007. I have about 12 worksheets within a workbook.

I want to know how I can clear the filters on all worksheets and return each
worksheet to showing all records without going through each worksheet
individually and clearing the filter.

ie. can I click or do something just once that will clear the filters in all
worksheets, or do I have to go to each s/sheet and clear the filter???

if this can only be done as a programming code, as i'm not really that
smart, can you please tell me where I have to put this code.
--
thanks
Cheryl