Select a sheet by double-clicking

[Bering]

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

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

Thanks!

 

[MoshiM]

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.

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Sheets("Main").Activate
End Sub

 

[Bering]

Thank you very much

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Sheets("Main").Activate
End Sub