double click on a cell to redirect
Have a minor question here. How so I assign a macro to a "double click" event?
the idea is that I have a list of names on one worksheet and the same names on the other worksheet within the workbook. Shen I double-click on the original list, the excel redirects me to the same ne in the second worksheet.
Does anyone have any ideas?
Thanks for thinking
A
Re: double click on a cell to redirect
You can use either of these events depending on the passed parameters that you may need.
VB Code:
'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