Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing VBA behind existing pivot table
Hello-
I think I have an easy question. While I can find the VBA behind a macro, how do I view the VBA behind an existing pivot table? Using the VB editor, where do I go? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing VBA behind existing pivot table
There is no VBA behind a pivot table.
You could record macro code to set up and manipulate a pivot table, but the coding behind the pivot table object itself is not exposed. -- John Green - Excel MVP Sydney Australia "Brett Clare" wrote in message om... Hello- I think I have an easy question. While I can find the VBA behind a macro, how do I view the VBA behind an existing pivot table? Using the VB editor, where do I go? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing VBA behind existing pivot table
Bret
VB is just a text file. If the Pivot Table was created manually without beig recorded there will be no macro to view. Regards Peter -----Original Message----- Hello- I think I have an easy question. While I can find the VBA behind a macro, how do I view the VBA behind an existing pivot table? Using the VB editor, where do I go? Thank you. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Adding to an existing Pivot Table | Excel Discussion (Misc queries) | |||
Creating pivot table to Existing worksheet | Excel Worksheet Functions | |||
adding a pivot table to an existing worksheet- HELP!! | Excel Discussion (Misc queries) | |||
Viewing source of a pivot table | Excel Discussion (Misc queries) |