ExcelBanter - Auto filter off

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Auto filter off (https://www.excelbanter.com/excel-programming/323497-auto-filter-off.html)

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

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

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