Navigate Workbook by Clicking Cells

The below code and workbook is a simpler way to navigate a workbook by clicking indicated cells so I don't have to move my mouse down to the bottom of the workbook. Double click whatever sheet you want to add it to per below:

Name your sheets like the below:

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Row = 2 And Target.Column = 2 Then
    Cancel = True
    ThisWorkbook.Sheets("HOME").Visible = -1
    ThisWorkbook.Sheets("HOME").Activate
    End If
End Sub

Comments are closed.