double click macros
 

Hi Jack,
You can just use code like this..

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Not Intersect(Target, Range("ABC")) Is Null Then
'do something here
ElseIf Not Intersect(Target, Range("DEF")) Is Null Then
'do something else here
End If
End Sub

Alok