Double Click

Hello Shark Man,

If this applies to a single sheet, you need to call the macro from within the Worksheet_BeforeDoubleClick event module of a given sheet.

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

If you want to apply this to worksheets, you need to use the Workbook_SheetBeforeDoubleClick event.

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