Pivot Table Macro
Look at the BeforeDoubleClick event. However this will fire before the
sheet is created.
Look at the NewSheet event in the thisworkbook module. It fires for me when
I double click a pivot cell. the SH argument in the event tells you what the
new sheet name is. You can then check that sheet and see if it has the kind
of information that would indicate it is produced by double clicking the
pivot cell. Or use both events in combination.
--
regards,
Tom Ogilvy
"Little Penny" wrote:
I have a pivot table and when I double click the pivot cell it fires
up another worksheet with my data. I then run a macro to format the
sheet to look the way I want. Is it possible to fire up this macro
when I double click the pivot cell.
|