Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Wizard in 2007 Jane N[_2_] Excel Discussion (Misc queries) 1 April 20th 10 05:52 PM
Pivot Table Wizard causes crash mike in texas Excel Worksheet Functions 1 March 10th 10 10:34 PM
Pivot Chart Created from Pivot Table is Blank RaidersFan Charts and Charting in Excel 1 January 25th 09 10:34 PM
Can I get SQL from Created Pivot table Farrukh Qadri[_2_] Excel Discussion (Misc queries) 0 October 26th 07 07:23 AM
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" Diana[_5_] Excel Programming 0 August 21st 03 10:19 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"