You can have your macro check first:

Option Explicit
Sub testme()
With ActiveSheet
If .FilterMode Then
.ShowAllData
End If
End With
End Sub

There are actual buttons on the Forms toolbar (view|toolbars|forms) that you can
use, too.

Kathy wrote:

Thank you for your replies. The problem I have is other users using the
spreadsheet do not have the "Show All" button on their toolbars so I was
trying to create on in the spreadsheet. After playing for a while I found
you can insert an object such as a square to look like a button and attach a
macro to it to make the filter reset. It works great until you click the
button a second time an error 1004 comes up - any suggestions?

"Dave Peterson" wrote:

I've dragged the ShowAll icon to my favorite toolbar.

Tools|Customize|commands tab|data category
scroll down looking for "Show All" and drag it to your toolbar.

Kathy wrote:

Is there a quicker way to reset filters then clicking on Data - filter -
show all?
Can I assign a cell to work as a "reset button"? If so how?

--

Dave Peterson


--

Dave Peterson