Apply a filter alert to "button"

[Jogier505]

I have 5 columns with an auto filter applied using the code below. I also have a form button in each column to reset the filter. What I would like is to have the form button turn "red' when the filter is applied and return to the orginal color when the filter is removed.

If it takes something other than a "form" button that is fine. I am looking for 2 "buttons" one to apply the filter, the other to alert you that the filter has been applied and to reset the filter when clicked.

I hope this is clear enough.

Apply Filter Code

Please Login or Register  to view this content.

Reset Filter Code

Please Login or Register  to view this content.

Thanks Jim O

[rwgrietveld]

Here is a pointer. See what you do with it. I use

Please Login or Register  to view this content.

[shg]

You can use a single button (I assumed an autoshape) and toggle between filtered and unfiltered:

Please Login or Register  to view this content.

[Jogier505]

I have been fussing with this for a while amd still have not been able to achive what I would like. Here is a sample sheet of what I have and what I am looking for.

Thanks, Jim O

[Leith Ross]

Hello Jim,

I replaced your "button" with an Control ToolBox Push Button. It changes colors from red to green and calls your macros to filter column G. Here is the code for the push button. The button and code have been added to the attached workbook.

Please Login or Register  to view this content.

[Jogier505]

Leith,

It works beautifully. That is just what I was trying to achive.

Thank you all for your time and input.

Jim O