Is there an easy way to capture when a user double-clicks a Pivot Data Item
to explode the details onto a new sheet? I would like to be able to flag the
sheet for later automated cleanup (deletion) and possibly give the sheet a
more meaningful name based upon the data clicked on.

I can forsee possibly using the double-click event together with the
..PivotCellType to set a public variable that can be "read" by the workbook's
NewSheet event, but I was hoping for something a little simpler.