Hello,
I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet.
I tried with the code below (ThisWorkbook module) but it does not work
Thanks!
I have a huge workbook with several tabs. I would like to be able to select the tab called "Main" by simply double-clicking anywhere in the spreadsheet.
I tried with the code below (ThisWorkbook module) but it does not work

Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Sheets("Main").Activate
'End Sub
Thanks!