double click on a cell to redirect

[RobDog888]

You can use either of these events depending on the passed parameters that you may need.

'Behind ThisWorkBook
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
 
End Sub
 
'Behind a Sheet
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    
End Sub