Toolbar button to clear Filter

[ar]

I do a lot of filtering so I have the AutoFilter button on the toolbar. I click the AutoFilter button to filter a column. Clicking on the AutoFilter button again will not clear the filter and I have to use menu commands (Data – Filter – AutoFilter) to uncheck AutoFilter. Is there no toolbar button function to clear the Filter?

 

[klb]

Copy this into a module to your personal.xls and then change the selection for your filter button to run this macro. It will turn the auto filter on or off

Sub clear_auto_filter()
'
' clear_auto_filter Macro

'
Selection.AutoFilter
End Sub