Toggle AutoFilter button

Oh good, that's one less macro to keep track of  I don't
know why I didn't see that before. Thanks!

-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Don
Guillett
Sent: Thursday, June 29, 2006 8:34 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Re: Toggle AutoFilter button


There is already one available that will show when filtered.

right click
toolbar>customize>commands>data>showall

Don Guillett
SalesAid Software
dguillett1austin.rr.com

----- Original Message ----- 
From: "Crystal Khan" <crystal.khanHOBBYLOBBY.COM>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Thursday, June 29, 2006 8:26 AM
Subject: Re: Toggle AutoFilter button


That's exactly what I've done to the AutoFilter button on
my toolbar. I've 
attached this macro to it:

Sub ToggleFilter()
Selection.AutoFilter
End Sub

And then the next button on my toolbar is a Show All button,
with this 
macro:

Sub SHOWALL()
On Error Resume Next
ActiveSheet.ShowAllData
End Sub

I filter alot and these 2 buttons makes it much easier.


-----Original Message-----
From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]On Behalf Of Shawn
Bumgarner
Sent: Thursday, June 29, 2006 8:18 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: Toggle AutoFilter button


Hi everyone, I have the autofilter button on one of my menu
bars in Excel 
(vers 2000) and I use it often but it bugs me that I can't
just hit it again 
when I want to toggle it off - I have to go to Data - Filter
- Autofilter to 
get rid of it.  Does anyone know of a way to change that or
a place on the 
web where some vba code exists that would accomplish this? 
Just curious, 
not a big deal but I do like to use it often.  Thanks!

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G