How to view VB Code behind Pivot Table created via Wizard
 

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?

How to view VB Code behind Pivot Table created via 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

--
Regards,
Tom Ogilvy

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