Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confirm Autofilter off
Can someone help with code turn simply state that the autofilter is turned
off. Or to confirm the status of autofilter: ie. Application.autofilter=false Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confirm Autofilter off
Got it: ActiveSheet.AutoFilterMode = False
I wasn't including the mode statement "Chris" wrote: Can someone help with code turn simply state that the autofilter is turned off. Or to confirm the status of autofilter: ie. Application.autofilter=false Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confirm Autofilter off
ActiveSheet.AutoFilterMode
if true then the arrows of the autofilter are visible. ActiveSheet.FilterMode if true then there is a filter criteria applied. (beside all) -- Regards, Tom Ogilvy "Chris" wrote in message ... Can someone help with code turn simply state that the autofilter is turned off. Or to confirm the status of autofilter: ie. Application.autofilter=false Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Confirm before deleting a worksheet? | Excel Discussion (Misc queries) | |||
Confirm formula change | Excel Programming | |||
Confirm deletion | Excel Programming | |||
Macro : confirm Delete | Excel Programming | |||
Please confirm the following bug in Excel | Excel Programming |