Hiro Protagonist
New Member
- Joined
- Jun 6, 2007
- Messages
- 1
I've got a workbook with a main sheet that holds all the data for a fairly complex Excel application. A couple of date entries from the main data are used in another sheet to determine the value of each entry in a graph used to show progress of certain goals.
This works fine when all the data is being considered, but I’ve recently been asked to modify it to allow people to use Autofilter on the main data so they can focus on only specific data.
I know essentially how I want to deal with the filtered data when recreating the chart, but I can’t figure out if I’m able to recognize when Autofilter has been run so I can then call the macro immediately after.
Does Autofilter raise a specific event, or do I just need to force them to run the macro after every filter is done?
This works fine when all the data is being considered, but I’ve recently been asked to modify it to allow people to use Autofilter on the main data so they can focus on only specific data.
I know essentially how I want to deal with the filtered data when recreating the chart, but I can’t figure out if I’m able to recognize when Autofilter has been run so I can then call the macro immediately after.
Does Autofilter raise a specific event, or do I just need to force them to run the macro after every filter is done?