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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet Calculate Event 2
Restore Autofilter After Macro Runs 1
Running macro operations in serial fashion 6
How to Unlock Excel Workbook protected by MACRO Password 6
Macro to update pivot table data range 3
Excel Help to copy information from one row at a time to another sheet 1
Combine 2 columns in a dynamic range into one 7
Run macro from active workbook whose name keeps changing 20

Back
Top