viewing VBA behind existing pivot table

  • Thread starter Thread starter Brett Clare
  • Start date Start date
B

Brett Clare

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.
 
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.
 
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
 
Back
Top