I have the code below in one of my worksheets. When I first put the code there it worked great. I could double click on a cell, and it took me to the sheet with that cell's name. I tried it today, and i get nothing. What am I missing?
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Sheets(Target.Value).Select
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Sheets(Target.Value).Select
End Sub