Penny, right click the pivot table sheet tab at the bottom of your screen
where all the sheet tabs are listed. Choose View code and use this event:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
MsgBox "You Double-Clicked Cell " & Target.Address
'Call Your macro here
End Sub
--
Charles Chickering

"A good example is twice the value of good advice."


"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.