hide a ws with either hyperlink or when main sheet is activated by selection

[dreamsinpixels]

My main objective is to hide a worksheet when a "main" sheet is activated. Whether it be done via hyperlink or when a main sheet is selected doesn't matter - as long as it the action hides the initially opened ws. I only want it to hide one sheet - not all and I need it to take into account the fact that the wb is categorically organized so there are about 10-12 "main" sheets within. I also need it to take into account hyperlinks that don't identically match such as Sapphire vs _Sapphire_

Thank you for ANY and ALL assistance!

dreamsinpixels

 

[Dan_W]

Did the solutions here not help? VBA to rehide a worksheet when hyperlink to the main sheet is clicked - Excel 16

 

[Micron]

Wow, not only double-posted but totally ignored the answers there.

 

[Dan_W]

Yeah, I'm not quite sure what's going on... I see that there had been a response, but there was nothing in the actual message that I could see, so...

 

[Joe4]

Duplicate to: VBA to rehide a worksheet when hyperlink to the main sheet is clicked - Excel 16

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.