Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a VB code when you click on the data field of a Pivot Table
Hello all,
When you click on the data the piovt provides, it brings up a new spread sheet with the data. How can I have a macro run on the new sheet? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run a VB code when you click on the data field of a Pivot Table
Hi,
What exactly are you trying to do? If you want Excel to provide you with a copy of the data that products the number you are clicking on, then forget a macro, just double click the number. If you double-click a subtotal or grand total you get all the records that contribute to that number. If this is not what you want, we really need a lot more details. With this feature on you won't be able to select an format within the pivot table and you will be launching the macro everytime you click in the data field. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "pgarcia" wrote: Hello all, When you click on the data the piovt provides, it brings up a new spread sheet with the data. How can I have a macro run on the new sheet? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table data field | Excel Discussion (Misc queries) | |||
use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
use field data from 1 pivot table in another? | Excel Worksheet Functions | |||
Pivot Table Field Data | Excel Worksheet Functions | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel |