Thanks for replying, John. I appreciate the help.

Ed

"JohnI in Brisbane" wrote in message
...
Ed,

ActiveSheet.AutoFilterMode = False

or

Worksheets("Sheet1").AutoFilterMode = False

regards,

JohnI


"Ed" wrote in message
...
I'm trying to turn off the AutoFilter in a macro using the following
code:
ActiveSheet.Select
Sheet1.AutoFilterMode = False

Of course, the reason I'm posting is that it doesn't work. It's stored
in
my Personal.xls, and needs to be used on the spreadsheets I create (I
use
a
certain template that will always have the information to be filtered on
Sheet1). Any help is appreciated.

Ed