Hi Marvin

There is a event in the Thisworkbook module for all sheets
Copy the code in there or the macro name

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

End Sub

In the sheet module it is named

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Marvin" wrote in message ...
I want to define an action for all sheets in my current workbook to occur
when I double click.

Is there a way that I can code the macro only once and sue it for all
worksheets, or must I define the macro for each sheet?

Thanks