Hyperlinks to Hidden Sheets and Back

[TeaPila]

Hello everyone:

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

 

[Chihiro]

Hi welcome to the forum. Please read through below.
https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Specifically below section.

• Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out.

I have removed it from your thread title.

 

[Chihiro]

As for your question. Yes it requires VBA. But to get faster response and answer that fits your need, please upload sample workbook that accurately represent how your workbook is currently set up (with desensitized info).

 

[Chihiro]

Just remembered I did something similar before. Have a read of thread below.
https://chandoo.org/forum/threads/adding-hyperlink-to-hidden-sheets.36863/