Hi all. Here's my problem.

I've got a custom macro that i've assigned to the right click (Pivot Chart Popup Command Bar) menu in a Pivot Chart.

This is used when I right click on a Pivot Field and select the custom macro. This could be any field.
What I need is for the Name or Index of the field i've clicked on to be passed to the Macro, but i can't work out how?
I know it must be able to be done because all the built in functions know what i've clicked on (EG: Remove Field)...


Any ideas.

Thanks,
Julian