Hey,
you can achieve the same by recording a new macro and giving it a name. U
can also save it as a button on the toolbar, so that it gives u a feel of
Form.


"Cheese" wrote:

I recently saw a spreadsheet (don't have the file) that used an Autofilter
for the column titles on a freezed pane. Very standard set-up that most of
you are well aware of. The big difference is that a Form-type button coupled
with a macro was set-up to reset all Autofilters in use. All you did was
press the button, named "Reset Filters" and voila - every user-defined
Autofilter was reset back to the "All" setting.

How can I replicate the same thing?