Hyperlink to Hidden tabs then hide again after completed data input.

**Toli** · 08-15-2012, 03:40 PM

I have a home page and 20 other tabs. I would like to work off the home page and hyperlink to one or more of the other 20 tabs and hide them by clicking on a close tab or return to home and have them close.
I have code that can open hidden tabs but I can't get the tabs to hide once I'm finished inputing. I've tried a number of VB codes but keep errors.

I would really appreciate it if anyone knows how to do this. I know it can be done I just can't make it happen I'm a bit new to the VB game.

Thanks in advance...

Toli

**vlady** · 08-15-2012, 08:30 PM

Why not use buttons instead of hyperlink?
there you could put all your codes in every button.

**JBeaucaire** · 08-16-2012, 12:44 AM

I would use a single macro in the ThisWorkbook module whose sole job is to hide every sheet when it is deactivated, except for the home sheet...sheet1, for instance.

Please Login or Register  to view this content.

**Toli** · 08-22-2012, 07:31 PM

Thanks Jerry...
This along with another piece of VB that I use works just like I need it to.

---------- Post added at 07:31 PM ---------- Previous post was at 07:23 PM ----------

Hi Vlady,
Thank you for the idea I tried the Button but I need to give the user the capabilty to jump to any page in the 20 at any time. So I went with text validation drop down window where the user clicks chooses the page then double clicks and is Hyperlinked. This can also be set up to automaticaly hyperlink from one to the other by setting up the dropdown windows. In this way you just need to double click and go without making a choice.
Thanks again I appreciate your help. Toli...