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