Hello everyone,
I want to run a macro after I click on a field of an
autofiltered table.(excel 2000)
I read about the worksheet change events here and in the
online help. The problem is that when you change the
filter the worksheet doesn't really change...all data is
there and the formulas obviously don't change...just the
values of some formulas.
Can anybody help me to accomplish this. I thank you in
advance.
Gustavo

Gustavo,

If this really is the case:

the formulas obviously don't change...just the values of some
formulas.

then you could use the worksheet's calculate event.

HTH,
Bernie
MS Excel MVP

"Gustavo" wrote in message
...
Hello everyone,
I want to run a macro after I click on a field of an
autofiltered table.(excel 2000)
I read about the worksheet change events here and in the
online help. The problem is that when you change the
filter the worksheet doesn't really change...all data is
there and the formulas obviously don't change...just the
values of some formulas.
Can anybody help me to accomplish this. I thank you in
advance.
Gustavo