Using Hyperlink to Hide/Unhide sheets in workbook.

[Ishwarind]

Hi All,
I have four sheets in workbook.
I want to have three different hyperlink in first sheet that should take me to rest of three sheets. But these three sheets should be hidden.
When I click on hyperlink for particular sheet, only that sheet should open. I want to have home hyperlink in remaining three sheets, which will take me back to first sheet.
When I will click on Home link, that sheet should get hidden and only first sheet should be open.

Is this possible to do?

Many Thanks for your help in advance.

[NeedForExcel]

See the file attached!

Just a basic code to do what you want

[cyiangou]

A hyperlink menu template:

LinkMenu.xlsm

Please Login or Register  to view this content.