Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Testing
Dear experts,
I am using macros on files that are shared by different users, and some of them use autofiltering to easily access data. How can I add to my macro a function (or anything else) to test if the autofilter in a worksheet is switched on, and in case switch it off? Many thanks. Kind regards, Valeria |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter Testing
There is no need to check. From "something I prepared earlier" Set SumSheet = ThisWorkbook.Worksheets("Consolidated") SumSheet.AutoFilterMode = Fals ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |