Apply all autofilters
 

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)

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.
--
Earl Kiosterud
www.smokeylake.com

"malcomio" wrote in message
...
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)