| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto filter off
I want to turn the auto filter off (or show all) on a worksheet whenever a
userform is initiated. Is it possible to write code in the userform procedure to achieve this? GK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto filter off
The AutoFilter property toggles, so you need to check its state using
AutoFilterMode: 'turn on autofilter If Not Worksheets("Sheet1").AutoFilterMode Then Worksheets("Sheet1").Range("A1").AutoFilter 'turn off autofilter If Worksheets("Sheet1").AutoFilterMode Then Worksheets("Sheet1").Range("A1").AutoFilter "gregork" wrote in message ... I want to turn the auto filter off (or show all) on a worksheet whenever a userform is initiated. Is it possible to write code in the userform procedure to achieve this? GK |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto filter off
Thanks for the solution Steve.
GK "Steve" wrote in message ... The AutoFilter property toggles, so you need to check its state using AutoFilterMode: 'turn on autofilter If Not Worksheets("Sheet1").AutoFilterMode Then Worksheets("Sheet1").Range("A1").AutoFilter 'turn off autofilter If Worksheets("Sheet1").AutoFilterMode Then Worksheets("Sheet1").Range("A1").AutoFilter "gregork" wrote in message ... I want to turn the auto filter off (or show all) on a worksheet whenever a userform is initiated. Is it possible to write code in the userform procedure to achieve this? GK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Linear Mode
