hyperlink to hidden sheets

Question

Hi,

I made a worksheet with more than 70 sheets. there is one main sheets that I created links whithin it to other sheets.

I want to hide all sheets and only main sheet remain. I know that if I hide any sheet , hyperlink will not work.

please help me.

Answer 1

Google is your friend ...

These tips have macros you need to unhide the worksheet

Hyperlinks to hidden sheets/tabs Excelhttps://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2010/hyperlinks-to-hidden-sheetstabs-excel/a5f5d428-e363-43ab-b386-6b7f652e2862****

This earlier question has a couple of examples you can look at

follow hyperlink to hidden sheet in Excel? (VBA)

https://www.extendoffice.com/documents/excel/4188-how-to-follow-hyperlink-to-hidden-sheet-in-excel.html

I have a workbook which contains multiple worksheets, the first master sheet has hyperlinks to other sheets, and now, I hide all sheets except the first one. In this case, the hyperlinks which link to hidden sheets are not available. But, how could you make these hyperlinks work successfully? When you click one hyperlink, the linked hidden sheet will be opened

.  *  Follow hyperlink to open hidden sheet with VBA code

.  *  Follow hyperlink to open hidden sheet and then hide it again with VBA code

Hyperlink to a Hidden Worksheet in Excel               2019 01 22

https://www.computergaga.com/blog/how-to-hyperlink-to-a-hidden-worksheet-in-excel/

Creating a hyperlink to another worksheet in Excel is easy. But if that worksheet is hidden then the hyperlink will not work. In this tutorial we provide a solution to follow a hyperlink to a hidden worksheet.