Xtreme Pivot Tables
August 17, 2018
I have couple worksheets and the first sheet is the Checklist (main sheet). I've created hyperlinks to the rest of the sheets from this main worksheet, I want to hide all of the sheets except the Checklist (main sheet) in which is easy to do; however, the hyperlink will not work if the sheets are hidden.
Is there a way that I can hyperlink the main sheet to the hidden sheets and then once I select "Back to Main sheet" it'll go hidden again? If hyperlink doesn't work can I use shapes linked to macros?
Thank you in advance.