Macro Hyperlinks
Closed
Boffee95
Posts
1
Registration date
Monday January 6, 2014
Status
Member
Last seen
January 6, 2014
-
Jan 6, 2014 at 03:48 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 16, 2014 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 16, 2014 at 11:57 AM
Related:
- Macro Hyperlinks
- How to find hyperlinks in word - Guide
- Spell number in excel without macro - Guide
- Ppt to pdf with hyperlinks - Guide
- Macro excel download - Download - Spreadsheets
- Remove all hyperlinks word - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jan 16, 2014 at 11:57 AM
Jan 16, 2014 at 11:57 AM
Hi Boffee,
You can't use hyperlinks on hidden sheets.
Try this code by implementing it in sheet1:
Whenever you double click on a sheet name in column D (row 12 and down) then the sheet will be made visible and activated.
You probably want to add another code to each individual sheet to hide the sheet again, when the sheet is deactivated for example.
Or you can hide all sheets again whenever sheet1 is selected. But that is up to you.
Best regards,
Trowa
You can't use hyperlinks on hidden sheets.
Try this code by implementing it in sheet1:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Range(Cells(12, "D"), Cells(12, "D").End(xlDown))) Is Nothing Then Exit Sub
Sheets(Target.Value).Visible = True
Sheets(Target.Value).Activate
End Sub
Whenever you double click on a sheet name in column D (row 12 and down) then the sheet will be made visible and activated.
You probably want to add another code to each individual sheet to hide the sheet again, when the sheet is deactivated for example.
Or you can hide all sheets again whenever sheet1 is selected. But that is up to you.
Best regards,
Trowa