Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Wizard in 2007 | Excel Discussion (Misc queries) | |||
Pivot Table Wizard causes crash | Excel Worksheet Functions | |||
Pivot Chart Created from Pivot Table is Blank | Charts and Charting in Excel | |||
Can I get SQL from Created Pivot table | Excel Discussion (Misc queries) | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |