Error Checking in Excel
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
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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
    Guest

    Default

    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?

    Marc

Some videos you may like

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
  •