If AutoFilter is set, do this

[Gabor]

G'Day,

How do I do this programmatically?

Please Login or Register  to view this content.

Any help is appreciated.

Sorry for it is a kindergarten-issue

Gabor

[mccreaso]

Hi,

Try:

Please Login or Register  to view this content.

mccreaso

[Gabor]

Thanks
Somehow it switches off the AutoFilter totally from the table.
But what I'd like to have is the actual filter for that column turned on and off alternating.
Maybe there's a way.
Gabor

[Carim]

Hi,

Are you looking for ...

Please Login or Register  to view this content.

[Gabor]

No,
What I am looking for is a toggle button that turns on and off a column's filter and leaving the AutoFilter mode of the table on all the time.
This is required because some other column's filter might be on that should remain on while I play with the button.
And I will apply this technique for about 7 columns.

Please Login or Register  to view this content.

Sorry that I'm a pain...

Gabor