Hiding a sheet AFTER having clicked a Hyperlink on said sheet

For Example.

The main tab is named Owners_Access.
This tab has many Hyperlinks to over 50 sheets. (They all work even if those sheets are already hidden, so no problem there).
The Hyperlinks from the sheets back to Owners_Access all work fine.
However...................as there are over 50 of them I do not want them all on show at the same time!
I only need one sheet on sight at any one time.
Question is:
"Can I have the Hyperlink that takes me back to the Owners_Access tab automatically HIDE that sheet?"
Thanks.

How are you managing to link to a sheet that is hidden? Are you using VBA? If so you need to provide more detail about your scheme works. It would be enormously helpful to attach your file, or at least a skinny version of it with only one linked sheet.

Getting to the Hidden sheets is easy:

This inside the Owners_Access tab

Please Login or Register  to view this content.

What's difficult is trying to apply code to the individual sheets that have Hyperlinks back to the Owners_Acces tab!
If I end up clicking 50 Hyperlinks from the Owners Access tab ill have 50 sheets open!
What's required is:

Go to Owners_Access tab.
Click on required Hyperlink to sheet.
Look at sheet contents.
Click on Hyperlink on that sheet that takes you back to Owners_Access tab

THEN (CRUCIALLY) by clicking on that sheets Hyperlink you HIDE that sheet.

This way you only have one sheet at a time open.

P.S. I'm not interested in some of the solutions whereby they HIDE all of the other sheets in the book!
Some other sheets need to be seen and available.
#Any code needs to be ONLY effective in the sheet with the back to Owners__Access hyperlink.

Cannot send you original as there is confidential info in there. But thanks for your interest.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Click on Hyperlink on that sheet that takes you back to Owners_Access tab

Where is that hyperlink located on the individual sheets? You can use a selection change event in the ThisWorkbook module but I'm not sure what happens if you hide the sheet before the link is executed. I would have to test that, but I need more info about your specific layout first.

There is no test book uploaded to any of your posts. See yellow banner at the top of the page.

Cracked it!
By altering all the necessary tabs to COLOR Yellow then using a button on each yellow tab attached to the following code:

Please Login or Register  to view this content.

Where there's a will there's a way!

You made it too complicated. Just change your existing macro as shown:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer