I have a workbook that has many hidden sheets within it (for many reasons). I am looking to create a worksheet with hyperlinks to these sheets, so that I can access them at any point a little easier than I do now.
So far, I have written the code to scan through each worksheet in the workbook and add those with
to the page, and add a hyperlink to that sheet from the name listed.
These hyperlinks work if the sheet is unhidden, but obviously this defeats the purpose of the entire task.
I have tried playing around with a few ideas in a
worksheet_followhyperlink
event but cannot come up with a solution.
I am sure it is pretty simple, but would appreciate a little help in finding the right solution.
Thanks
Bookmarks