Check out the VBA help for the Activate Event and the Example.

"Brian" wrote in message
...
What code do I need to write, if I would like an advanced filter to run
everytime I click on a particular worksheet.

So if I go to worksheet A and change something then the next time I go to
worksheet b the advanced filter will have automatically run for me?

I am able to get this far.

Range("C8:AH233").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=
_
Range("BA3:BA4"), Unique:=False