I know that this has been answered loooong time ago but I read through it
for my problem and I ended up with a different solution.

I wanted the button to appear on the document itself for users who have no
idea how to use Excel. I recorded a macro which had me select the title row,
go to data then filter than autofilter (which turned the filter on) and then
selected the first cell of my data and turned the recorder off. I then
attached this macro to a button which I placed on the document. I only
needed one macro as running the macro again toggled the check mark to off.
Everytime the button is selected the filter turns off and on.

The purpose for this was for users who can't remember what they filtered on
to get back all of the records without having to use the toolbars. (I know
the arrow turns blue but they wanted something pretty foolproof)

"Dennis S." wrote:

I've added a button on the toolbar to turn on Autofilter. How can I add
another button to turn Autofilter off?