Automation

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

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

"Brian" <[email protected]> wrote in message
news:[email protected]...
> 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