Run a VB code when you click on the data field of a Pivot Table

  • Thread starter Thread starter pgarcia
  • Start date Start date
P

pgarcia

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table VB code? 1
about pivot table 1
Excel 2007: Help creating a macro that will run Solver? 3
Pivot Tables & External Data 1
Run Macro when click on different tab in Excel 3
copy a pivot table to another sheet in a macro 1
Pasted Pivot Table looks at old sheet 1
Linking Pivot Table data 3

Back
Top