Hello! I am new to the forum and am constructing a large multi-sheet workbook for personal use. I and am using simple macros to help with page navigation. On one sheet I want to double click on a single cell in a range of cells and have the corresponding individual macros take me to the corresponding worksheets. I know how to construct simple macros and developed simple code that takes me to a single worksheet but I would like to expand the code statement to take me to different worksheets depending on the cell I double click on. The cells I will click on are are all in one column on one sheet. Thanks in advance for your help.
Here is what I have that works;
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Selection.Count = 1 Then
If Not Intersect(Target, Range("B21")) Is Nothing Then
Call FIDSX
End If
End If
End Sub
Steve
Bookmarks