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
Bookmarks