Excel Help

[JimBeam]

Does anybody know how to allow a hyperlink to a tab that is hidden within the same workbook ?
I have a switchboard setup ( as the only visible tab ) with links to several worksheets that are hidden. If you try and jump to them while they are hidden there's an error.
If I unhide the sheets there is no problem.
There's really no need for the switchboard if the user can just click on the tabs.
Keep in mind that I'm doing this straight through Ecel and not using any Visual Basic.
Any ideas ?

I have balls !!!

[badorties]

if you hyperlink to a hidden tab, you won't see the info because it's hidden ...

if you just point the switchboard cell to [=hiddentab!cell], and then hide the sheet, the reference will remain ...

i'm not sure if that's what you mean by a 'hyperlink' ...



<img src="http://scripts.cgispy.com/image.cgi?u=badorties"><br>

+|+|+|+|+|+|+|+|+|+|+|+|+|+|+

[LordJezo]

Go ask your question here... (http://www.excelforum.com/)

------------------------
I KISS YOU!

[Reephdweller]

Go ask your question here...



Lezo's right, almost no one asks Excel questions on this board.


[I'm too lazy to find the hundreds of threads throughout this board devoted to the subject of excel conundrums]



<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>