Nightlytic
Member
Hi,
I'm looking to replicate this:
https://www.atlaspm.com/toms-tutori...zing-your-rightclick-menu-to-list-run-macros/
There is a sample workbook there at the bottom of the page. But it's Excel 2003, I work with 2010!
However, I need the above to work for a pivot table menu instead of the normal menu this macro works on, so that if I right click on a value in my pivot table, a macro shows that I can execute if I select it. I've tried changing the "Cell" for "Pivot Table Context Menu", which doesn't seem to work, I gotta say I don't really understand the macro here and could use some help...
Alternatively, or also, is there any way to disable the functionality (on a workbook/pivot/worksheet) where you double click on a pivot table value and it creates a new tab with the relevant cache? If I could do that I could substitute that for my macro, that pulls proper information.
My end goal is that anybody looking at a pivot table can quickly (right click and run macro 'show details' or double left click) on a value and this will fire up a macro that brings up details (taking the X and Y labels and filtering table/access) I have that part more or less built just can't get the right user functionality for it.
Thanks!
I'm looking to replicate this:
https://www.atlaspm.com/toms-tutori...zing-your-rightclick-menu-to-list-run-macros/
There is a sample workbook there at the bottom of the page. But it's Excel 2003, I work with 2010!
However, I need the above to work for a pivot table menu instead of the normal menu this macro works on, so that if I right click on a value in my pivot table, a macro shows that I can execute if I select it. I've tried changing the "Cell" for "Pivot Table Context Menu", which doesn't seem to work, I gotta say I don't really understand the macro here and could use some help...
Alternatively, or also, is there any way to disable the functionality (on a workbook/pivot/worksheet) where you double click on a pivot table value and it creates a new tab with the relevant cache? If I could do that I could substitute that for my macro, that pulls proper information.
My end goal is that anybody looking at a pivot table can quickly (right click and run macro 'show details' or double left click) on a value and this will fire up a macro that brings up details (taking the X and Y labels and filtering table/access) I have that part more or less built just can't get the right user functionality for it.
Thanks!
