My preference, as far as shortcuts are concerned, mostly involves toolbar
buttons.
There is one to reset all filters to "Show All".
There is one to switch the Auto Filter On,
but there appears to be no Toolbar button to switch Auto-Filter off
completely.
It would make sense to me to be able to use one button to toggle the Auto
Filter.
Is there a way of creating such a button (in VB)?

I cheat.

I select the row with the headers.
I hit the delete key. The data in those header cells is erased and the
autofilter arrows removed.
I hit ctrl-z to put the data back.

Be careful.

Pastel Hughes wrote:

My preference, as far as shortcuts are concerned, mostly involves toolbar
buttons.
There is one to reset all filters to "Show All".
There is one to switch the Auto Filter On,
but there appears to be no Toolbar button to switch Auto-Filter off
completely.
It would make sense to me to be able to use one button to toggle the Auto
Filter.
Is there a way of creating such a button (in VB)?

--

Dave Peterson

Sub Clear_Filter()
On Error GoTo whoops
Selection.AutoFilter
Exit Sub
whoops:
MsgBox "no range selected"
End Sub

Toggles AF on/off


Gord Dibben MS Excel MVP

On Thu, 26 Oct 2006 11:35:01 -0700, Pastel Hughes
wrote:

My preference, as far as shortcuts are concerned, mostly involves toolbar
buttons.
There is one to reset all filters to "Show All".
There is one to switch the Auto Filter On,
but there appears to be no Toolbar button to switch Auto-Filter off
completely.
It would make sense to me to be able to use one button to toggle the Auto
Filter.
Is there a way of creating such a button (in VB)?