IF AutoFilter is on, turn it off
Hi Chuck
Sub test()
MsgBox ActiveSheet.AutoFilterMode
End Sub
HTH. Best wishes Harald
"CLR" skrev i melding
...
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
|