opc10
06-20-2007, 08:03 PM
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
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