| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter
how can I (with VBA) turn off the Autofilter or turn on
the autofilter regardless of its current state? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter
This works for me. ws represents a worksheet, since
AutoFilterMode is a worksheet property. If ws.AutoFilterMode = True Then ws.AutoFilterMode = False End If Diane -----Original Message----- how can I (with VBA) turn off the Autofilter or turn on the autofilter regardless of its current state? . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter
Thank you.
I tried ActiveSheet.AutoFilterMode = False which seems to work OK but when I try ActiveSheet.AutoFilterMode = True it never works. Can you tell what I'm doing wrong? Thanks again, Connie -----Original Message----- This works for me. ws represents a worksheet, since AutoFilterMode is a worksheet property. If ws.AutoFilterMode = True Then ws.AutoFilterMode = False End If Diane -----Original Message----- how can I (with VBA) turn off the Autofilter or turn on the autofilter regardless of its current state? . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofilter
You can turn it off that way, but you have to autofilter a range.
Record a macro and you'll see the code. Connie wrote: Thank you. I tried ActiveSheet.AutoFilterMode = False which seems to work OK but when I try ActiveSheet.AutoFilterMode = True it never works. Can you tell what I'm doing wrong? Thanks again, Connie -----Original Message----- This works for me. ws represents a worksheet, since AutoFilterMode is a worksheet property. If ws.AutoFilterMode = True Then ws.AutoFilterMode = False End If Diane -----Original Message----- how can I (with VBA) turn off the Autofilter or turn on the autofilter regardless of its current state? . . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
| 2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Linear Mode
