Filter Switches vs Macro?

Excel 2000 ... I have Filter Switches which I activate
with various recorded Macros (1 Filter Switch per
Macro) ... this is working fine as long as there is not a
Filter Switch already activated.

Above said ... I need a little Macro instruction I can
paste into my recorded Macros that will set any activated
Filter Switches back to ALL before activating the Filter
Switch I am calling for???

This so I do not get multiple Filter Switches activated by
my Macros ... Thanks ... Kha

Selection.AutoFilter

resets all filters
HTH,
Gary Brown


"Ken" wrote:

> Excel 2000 ... I have Filter Switches which I activate
> with various recorded Macros (1 Filter Switch per
> Macro) ... this is working fine as long as there is not a
> Filter Switch already activated.
>
> Above said ... I need a little Macro instruction I can
> paste into my recorded Macros that will set any activated
> Filter Switches back to ALL before activating the Filter
> Switch I am calling for???
>
> This so I do not get multiple Filter Switches activated by
> my Macros ... Thanks ... Kha
>

>-----Original Message-----
> Selection.AutoFilter
>
>resets all filters
>HTH,
>Gary Brown
>
>
>"Ken" wrote:
>
>> Excel 2000 ... I have Filter Switches which I activate
>> with various recorded Macros (1 Filter Switch per
>> Macro) ... this is working fine as long as there is not
a
>> Filter Switch already activated.
>>
>> Above said ... I need a little Macro instruction I can
>> paste into my recorded Macros that will set any
activated
>> Filter Switches back to ALL before activating the
Filter
>> Switch I am calling for???
>>
>> This so I do not get multiple Filter Switches activated
by
>> my Macros ... Thanks ... Kha
>>
>.
>

A couple more options:

on error resume next
activesheet.showallData
on error goto 0

or if you want to check yourself:


With ActiveSheet
If .FilterMode Then
.ShowAllData
End If
End With



Ken wrote:
>
> Excel 2000 ... I have Filter Switches which I activate
> with various recorded Macros (1 Filter Switch per
> Macro) ... this is working fine as long as there is not a
> Filter Switch already activated.
>
> Above said ... I need a little Macro instruction I can
> paste into my recorded Macros that will set any activated
> Filter Switches back to ALL before activating the Filter
> Switch I am calling for???
>
> This so I do not get multiple Filter Switches activated by
> my Macros ... Thanks ... Kha

--

Dave Peterson