Macro to turn off autofilter when exiting sheet not working

[Mr_Phil]

Hi there. I'm thinking this isn't working because it only applies to an active worksheet. But, I want to confirm that and ask for ideas. I am not great at VBA but I can follow along and look up anything I don't readily understand.

I have a worksheet that needs autofilters on while in the sheet updating things. But, it is critical the user remember to turn the autofilters off before switching to a different tab. If they are left filtered, the filtered data won't update when other processes try to.

Here is what I came up with. It doesn't work. I'm thinking that since it specifies activesheet it can't reach back to the sheet as I leave it?

Edit: In the VBA EXPLORER this code is not in a module but on the appropriate sheet.

Please Login or Register  to view this content.

As always I really appreciate the time you guys take to help us. Thanks.

[Fluff13]

How about

Please Login or Register  to view this content.

[Mr_Phil]

How about

Please Login or Register  to view this content.

score! THAT did the trick. Thank you, thank you, thank you.

[Fluff13]

You're welcome & thanks for the feedback.