Click Developer Ribbon > Insert > ActiveXControls: CommandButton.
Draw a button on your worksheet.
Right click button > View code
This takes you to the VBE (visual basic editor) where you can edit macros.
You will see something like:
Enter the code from above into this sub, so it looks like:
Change the range reference, filter field number and criteria text to suit what you want.
Press Alt-Q to close the VBE and return to Excel.
Click Developer Ribbon > Design Mode, to turn design mode off again.
You can now click your button to apply / remove a filter.
Bookmarks