Apply all autofilters

[Guest]

Is there a way of re-applying all the autofilters in a workbook? I've got
several autofilters on different worksheets, and it will be useful to be able
to apply all the filters at once, rather than going through each worksheet
and doing it manually.

(Excel 2003)

 

[Earl Kiosterud]

Malcomio,

You could record a macro as you apply the autofilters. Be sure to start the
recorder before you select the first sheet, or the macro will start in the
sheet you happen to be in when it's run.