Hyperlinks to Hidden Sheets - Beginner Excel User

[teapila]

Hi there

I have a worksheet with 8 Sheets. The first sheet is a summary and I’ve created hyperlinks to 3 of the other sheets for a person to access from the main page. [Sheet names: Premium Breakdown (Sheet 1), PA Group Rank (Sheet 2), 2016 Premium Breakdown (Sheet 3), 2017 Premium Breakdown (Sheet 4).] I am also trying to have another sheet (not mentioned yet) be a sheet that would have the same purpose. [Sheet names: ISO (Sheet 5), Compilation (Sheet 6), Segments (Sheet 7), Segments 2 (Sheet 8).]

I want to hide all sheets except for the sheets 1 and 5, which I can do and works fine. But from there, I still want the hyperlinks to work. I need the hyperlinks to open (unhide) the hidden page and then close(hide) it again when I click on the “Back” hyperlink I have added to each of the hidden pages.

Is this possible? Will you please tell me how to do it? I have not done anything with macros or VBA before so the more detail, the better!

Thank you

Tea Pila

 

[Logit]

.
Study the example workbook provide at this resource :

https://chandoo.org/forum/threads/how-to-hyperlink-to-cells-in-hidden-worksheet.18906/

 

[teapila]

Hi Logit:

I'm sorry the thread was confusing. Is there any way you could further help me on my issue?

Thanks!

 

[Logit]

.
This macro gets pasted in the SUMMARY sheet level module :

Option Explicit


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Updateby Extendoffice 20161109
    Application.ScreenUpdating = False
    On Error Resume Next
    If Target.Column = 1 Then
        Sheets(Target.Value).Visible = xlSheetVisible
        Sheets(Target.Value).Select
    End If
    Application.ScreenUpdating = True
End Sub

Right click on the SUMMARY sheet tab, select VIEW CODE and paste the above macro into the code window on the right.

This macro gets pasted into the sheet level module for the following sheets (follow the same instructions on 'right clicking the SUMMARY tab' for each sheet) :
PA Group Rank, 2016 Premium Breakdown, 2017 Premium Breakdown, Compilation, Segments, Segments 2

Option Explicit
Private Sub Worksheet_Deactivate()
On Error Resume Next
    Me.Visible = xlSheetVeryHidden
End Sub

Download sample workbook : https://www.amazon.com/clouddrive/share/XK50jkf7VpN96AinP9F6dUjsf3UWy20d0Jr5yMr707