ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot table programming (https://www.excelbanter.com/excel-programming/399076-pivot-table-programming.html)

Ashok

Pivot table programming
 
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

Pivot table programming
 
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ashok" wrote in message
...
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





All times are GMT +1. The time now is 11:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com