RE: IF AutoFilter is on, turn it off

Tech-Archive recommends: Fix windows errors by optimizing your registry

The only thing about Toppers version is, if auto filter is already off, it
generates an error. Unless of course you trap that error...?

"CLR" wrote:

> Thank you very much.......of the ones suggested so far, I think this is the
> method I prefer....
>
> Thanks again,
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
>
> "Toppers" wrote:
>
> > Hi,
> >
> > Worksheets("Sheet1").AutoFilterMode = False
> >
> >
> > "CLR" wrote:
> >
> > > Hi all....
> > >
> > > I know I can toggle the Autofilter on and off with the line
> > > "Selection.Autofilter", but when I send a user to a *** from my Main Menu,
> > > I do not know if Autofilter is on there, or not.......I would like to turn it
> > > off if it has been left on........help please.....
> > >
> > > Vaya con Dios,
> > > Chuck, CABGx3
> > >
> > >
.

Quantcast