View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Green[_2_] John Green[_2_] is offline
external usenet poster
 
Posts: 58
Default 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.