VBA to modify new sheet created by pivot

[Rastaman]

Hi all,
When one double clicks on any of the data values in a pivot table, a new worksheet is created that contains the detailed data for that pivot cell. I would like to be able to modify this new sheet when it is created. Specifically, I want to turn on AutoFilter and sort descending by one of the columns. Is there any code that can detect this new sheet and trigger a macro to make these edits?

Thanks,

Rick

 

[Rastaman]

Anyone? Can't be done? Looks like basically the same question today from JimBobBillyJean:

http://www.mrexcel.com/forum/showthread.php?t=376188