VBA code to go back once drilled down on pivot table

[ZuneidDassu]

I have created a dashboard with a number of pivot tables in excel 2007. The users would go to the pivot table and double click on the data and all of the information is revealed in a separate sheet. In order for them to go back they currently click on Ctrl Z where a message box appears asking if you would like to delete the sheet or Cancel to stay on the sheet. Once the User clicks on Delete the sheet is deleted and they go back to the relevant Pivot table. Is there any way in which I can enter some code and a button for them to press at the bottom of the data produced from drilling down on the Pivot to take them back to the appropriate Pivot table.

Your help in this matter is much appreciated as I am a novice when it comes to VBA code

[dflak]

If you are going to do this by double clicking on the pivot table, then I don't think if can be done. It's sort like invoking the inverse of a go to command: the come from command. In all my years of programming I haven't figured out how to do that one.

However, if you make a before double click event, you can make this happen. Personally, I am surprised this works. The sheet that contains the pivot table is called Pivot. The code is in the module on that page:

Please Login or Register  to view this content.

I mapped the subroutine Recover to CTRL-r. So when you double click, you open up the new sheet. When you click CTRL-R, you are returned to the sheet named Pivot.

[ZuneidDassu]

Thanks this has now been closed