+ Reply to Thread
Results 1 to 2 of 2

How to view VB Code behind Pivot Table created via Wizard

  1. #1
    Firemark1817
    Guest

    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. #2
    Tom Ogilvy
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1