View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Auto Filter Toolbar Button Does not Toggle

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)?