Pivot table programming

[Guest]

Hi,

I have Pivot table report in Excel 2003. I am not sure I can do this or not
please let me know if it is possible.

When we select a cell in pivot table (not out side of pivot table) and right
click we can menu. I want to add my own menu item in that menu like user can
select this new menu item which can open another windows application and pass
the data in that cell.

Thank you - Ashok

 

[Jon Peltier]

You need to change the "PivotTable Context Menu" commandbar.

How to customize menus and menu bars in Excel
http://support.microsoft.com/kb/830502
click the link for "Create a command on a shortcut menu bar" under "Shortcut
menus"

- Jon