How to use macros to open hidden tabs from a master worksheet?

**Jon Gray** · 07-16-2013, 10:53 AM

Hello,

I am creating a document that has multiple tabs (up to 300!). I would like to have only the 'master' sheet visible. On this master sheet, I have a number of descriptions that currently hyperlink the description to a tab that will show an image. The user is then able to click anywhere on the tab to return back to the master sheet. I would like to hide all the tabs, but if I do this the hyperlinks on the master sheet do not work!

I have read many posts, YouTube clips and Googled the above, and am not satisfactorily confused!

I think I need to somehow use macro/s to do this task but I honestly do not understand where to start. It really is another language to me.

Is anyone able to help?

I have attached a cutdown version of the file to view. If you click on "Rocker arm cover" and then "Oil filler neck", I hope this will explain what I am rambling on about!

Many thanks

Jon

**6StringJazzer** · 07-17-2013, 09:00 AM

Welcome to the Forum!

Here is one solution using VBA.
[Jon Gray=hyperlinks to hidden sheets=Inspection_Test.xlsm]
However, you need to change the hyperlinks in your hidden sheets to refer back to some other cell in the main sheet.

The hyperlinks in 5430i_Concept have been removed, and VBA code has replaced them. The VBA code detects when the user selects an item in column B of 5430i_Concept. If there is a valid sheet corresponding to that item (using the same name as the number in column A), then that sheet is un-hidden and activated. When the user returns to 5430i_Concept, all sheets are once again hidden.

The reason you have to change the hyperlink is that it currently returns to the same item in column B, which will again trigger the macro to return to the same hidden sheet.

**Jon Gray** · 07-17-2013, 03:30 PM

Unbelievable! Thank you very much. I've not a clue how you've done it, but that's exactly what I was looking for. I'll attempt to copy this macro to my original file to see if I can get that to work as well!

...I may be back for more answers :0) !

Thanks again

Jon