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

Will the Workbook_SheetBeforeDoubleClick event be useful?

--
Cheers
Nigel



"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

Hi,
Use Workbooks' Before double click event.
Alok

"Marvin" wrote:

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

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

Hi Marvin,

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?

Use the Thisworkbook's Workbook_SheetBeforeDoubleClick event

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com