Only unhide sheet when hyperlink is clicked that directs to the sheet

I have a Main TAB that has links to sheets Apple, Orange & Pear. I always want sheets Apple, Orange & Pear hidden UNLESS I click the link on the Main TAB that directs me to one of those sheets. In that case, the sheet would unhide until it is no longer active, then it would go back to hidden.

My final workbook will have a Main TAB and 50 other tabs (Apple, Orange, Pear, Grape, Banana, Kiwi.... etc.). All the hyperlinks will already be on the tabs. Each hyperlink has a random defined name (eg. "_30542226" "_91303912"... etc.). I am looking for a macro that can identify when the link from the Main TAB is referencing to a defined name on another sheet, then unhide it. Thanks!

Ok, this gets the destination defined name:

HTML Code: 

How can I get the destination sheet?

Hi,

'cause the SheetFollowHyperlink event starts after the link process,
better should to remove links and use buttons !

Anyway, with a few tweaks … Code to insert in the ThisWorkbook module :

Please Login or Register  to view this content.

Works great, thanks!

Please Login or Register  to view this content.

Any chance to see my reputation growing ?