Thanks Dave!

A quick macro recording of that button being pressed gives me
"Activesheet.showalldata" which is exactly what I'm looking for.

Cheers!

Dave Peterson wrote:
You can add a "Show All" button to your favorite toolbar (especially handy if
you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.

MJ wrote:

I have an Excel List created. When users start using it they often add
filters here and there and have a hard time remembering which ones they
had on and off to reset them back to the normal, unfiltered view.

Is there a way I can attach some code to a button that resets all the
filters in a list to an unfiltered state?

tia

--

Dave Peterson