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