Thank you very much Kind Sir.

Vaya con dios,
Chuck, CABGx3



"Harald Staff" wrote:

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