How to view VB Code behind Pivot Table created via Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several Pivot Tables created by using the Pivot Table Wizard but need
to make some customizations to the VB code. How can I view the VB Code built
by the Pivot Table Wizard?
 
Actually there is no VB code built when you use the pivot table wizard.
However, there are commands that will perform the same function. You can
recreate your tables with the macro recorder turned on, then modify the
recorded code to perform the action you want. You can also study the
objects, properties and methods associated with the pivot table and use
those to do what you want.

go to Debra Dalgleish's site and look a P on this page for Pivot Table. It
should give you some ideas:

http://www.contextures.com/tiptech.html
 
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

Unable to Group in Pivot Table 1
Pivot table multiple filters 2
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot table code question 2
Excel 2010 Pivot Table 2
Using VBA to create charts 1
Wanted to show 12 month Date in Pivot table 2
Playing back a Pivot Table macros 2

Back
Top