Hi,

I am using Excel 2007 and trying to figure out the code to select different pivot charts through vba using a button and apply filtering to the selected chart. For instance, I have 4 pivot charts on a sheet and I want to be able to select "chart A" and apply filtering...then using the same button select "chart B" and apply filtering.

I have tried "Case statements" and "If statements" to no avail. I can't figure out the code that allows you to click on the activated chart. I already know the code to activate a chart - but, again; I don't know how to determine which chart is activated and use that to apply filtering.