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?

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

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

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

Thanks Dave - I am not good at writing Macros - I usually record them.
Something I would like to learn but I typed in what you wrote below and I get
a compile error - Invalid inside procedure - any suggestions what I am going
wrong?

"Dave Peterson" wrote:

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

This is procedure all its own. It doesn't go inside the existing code--it
replaces it.

Well, that is if your existing code doesn't do anything else.

You may want to just copy the guts of the code and place it into your procedu

This is the guts (ewww!):

With ActiveSheet
If .FilterMode Then
.ShowAllData
End If
End With



Kathy wrote:

Thanks Dave - I am not good at writing Macros - I usually record them.
Something I would like to learn but I typed in what you wrote below and I get
a compile error - Invalid inside procedure - any suggestions what I am going
wrong?

"Dave Peterson" wrote:

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


--

Dave Peterson

You can use the drop down in the header field, but maybe this is not quicker
that the one you use.
Other option is customize the toolbars, adding the "Show all" button there
(Tools - Customize - Commands - Select data in categories - Drag & drop
"Show all" to the toolbar)

Hope this helps,
Miguel.

"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?