Run macro after data changes

  • Thread starter Thread starter Gustavo
  • Start date Start date
G

Gustavo

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
Click to expand...
formulas.

then you could use the worksheet's calculate event.

HTH,
Bernie
MS Excel MVP
 
Back
Top