add in a button in pivot table ?

[uponebuck]

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.

 

[Guest]

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