aron.ridgway
New Member
- Joined
- Nov 16, 2009
- Messages
- 3
I am trying to control what happens when a pivot table is double clicked?
Currently when i double click it creates a new sheet with the data.
I want to be able to rename the new sheet to the existing Sheetname with the pivot table eg. CustomerInterests + the word 'Data' on the end.
I also want to create/copy an Oval object that is acting like a button on the new sheet, I want the button to delete the newly created sheet and return back to the pivot table.
any tips or hints would be great!
Currently when i double click it creates a new sheet with the data.
I want to be able to rename the new sheet to the existing Sheetname with the pivot table eg. CustomerInterests + the word 'Data' on the end.
I also want to create/copy an Oval object that is acting like a button on the new sheet, I want the button to delete the newly created sheet and return back to the pivot table.
any tips or hints would be great!