Hyperlinking to Hidden Worksheets (with some complications)

Hi there,

I'm trying to get it so that upon opening the sheet 25 of my 28 worksheets in a workbook are hidden, then when a hyperlink is clicked on 1 of the 3 visible worksheets it opens the hidden sheet, and hides it again once the user goes back to the visible sheets.

...is that possible? I found a forum post on Ozgrid that seemed to give me macros for what I needed ( http://www.ozgrid.com/forum/showthre...185#post540185 ) but they I can't them to work on my sheet (I keep getting runtime error 9), and simpler codes I've found give me runtime error 5.

Can anyone help? Here is my worksheet attached:
Risk Heat Map Draft 15.xls
Due to attachment limit I've had to cut down the number of background worksheets I have, so "Risk Table - EDITABLE", "GxP Risk Heat Map" and "Risk Metrics" would all remain visible, while "1-1" and "1-2" would be hidden. On top of these there are sheets "1-3","1-4","1-5","2-1","2-2","2-3" all the way up to "5-5" making 25 in total.

I'm completely unaquainted with Visual Basic so sorry if I'm missing something really simple! Thanks for any help!

David

hi David, please check attachment.

I've added the following sheets: 1-3,1-4,1-5,2-1 for testing.

If sheet exists you will be transfered to it. Once you move to the one of the "always visible sheets", it will be hidden. If nothing happens on hyperlink click or activating the cell that contains hyperlink and sheet is existing, run code "Enable_Events" and try again.

Thanks so much for this, it's perfect!!

Do you know how I could add sheets to in the future that I don't want to automatically hide? Do I need to change the coding?

Thanks again,
David

ThisWorkbook code:

Please Login or Register  to view this content.

Bold and underlined text is a string combined from sheet names that always stay visible

Awesome thank you so much!