View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valeria[_2_] Valeria[_2_] is offline
external usenet poster
 
Posts: 24
Default 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