View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default IF AutoFilter is on, turn it off

Thank you very much.......of the ones suggested so far, I think this is the
method I prefer....

Thanks again,
Vaya con Dios,
Chuck, CABGx3





"Toppers" wrote:

Hi,

Worksheets("Sheet1").AutoFilterMode = False


"CLR" wrote:

Hi all....

I know I can toggle the Autofilter on and off with the line
"Selection.Autofilter", but when I send a user to a Sheet from my Main Menu,
I do not know if Autofilter is on there, or not.......I would like to turn it
off if it has been left on........help please.....

Vaya con Dios,
Chuck, CABGx3