Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn AutoFilter off by code?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba code on autofilter | Excel Discussion (Misc queries) | |||
Macro turn off AutoFilter | Excel Worksheet Functions | |||
Autofilter code | Excel Discussion (Misc queries) | |||
Excel 2003 - turn off option in autofilter | Excel Discussion (Misc queries) | |||
Turn this into VBA code | Excel Programming |