View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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.