| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
-----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 . |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Filter Switches vs Sheet Protection? | Excel Discussion (Misc queries) | |||
| Date macro | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
