Jet Fusion
Member
Hi all,
I have a workbook that has Icons with hyperlinks to hidden sheets and then hides them once you go back to the main sheet (sheet 1).
My issue is when i click on normal text hyperlink it works (testing code) but when I click on the icons the hyperlink does not work. When I unhide the sheets and click on the sheet 1 they go to the sheet but once they are hidden and I try to access them again from sheet 1 they don't open the hidden sheets.
I have the code i'm using in the attached file.
Thanks
I have a workbook that has Icons with hyperlinks to hidden sheets and then hides them once you go back to the main sheet (sheet 1).
My issue is when i click on normal text hyperlink it works (testing code) but when I click on the icons the hyperlink does not work. When I unhide the sheets and click on the sheet 1 they go to the sheet but once they are hidden and I try to access them again from sheet 1 they don't open the hidden sheets.
I have the code i'm using in the attached file.
Thanks