macro action after double clicking pivot table

[stattouk]

Written in Excel2007 (but would be helpful if ran in 2003 also)

Hi

I have a pivot table where I ask the end user to double click their data line which then opens up the drilled down info on a new tab.

I then have to ask them to run a macro using 'ctl+f' to format this set of data (each person data can have different lines of information).

How can I automatically run the macro after the end user double clicks the pivot data? Many thanks.

 

[stattouk]

Hi All

Sorry worked this one out. I put the code for Workbook_NewSheet into ThisWorkbook. After a few tweaks the code runs on my PC. Just need to see if it runs on others now.
This thread can be closed.