add in a button in pivot table ?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: add in a button in pivot table ?

  1. #1
    New Member
    Join Date
    Mar 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    I have a pivot table that varies each month and I would like to add in a kind of of VB botton that would permit to create a temp
    worksheet with derived data from table. ( The button will permit to explode the data on a specific line of pivot table).

    Just want to know how to add a button in pivot table and I will add in the vb code afterwards for the temp worksheet.

    thanks to all.

  2. #2


    You can add a button by using the "Control Toolbox" toolbar (View - Toolbars). Double click on the button you just created to add VBA code.

    By the way, did you know you can drill down on a row of a pivot table simply by double clicking on the desired data field?


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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