Hyperlink to Hidden Sheet

[muziq2]

Hi,

I'm trying to use the hyperlink function to jump to another sheet i
the same workbook when the link is clicked. However, unless the lin
is clicked I would like the sheet to be hidden.

After the link is clicked I don't care what happens to the sheet but i
there is a way to "re-hide" the sheet when the user selects anothe
sheet that would be great.

Right now I use the following formula:
=HYPERLINK("filename.xls]'sheetname'!a1","Drill Down")

This formula works only when the sheet is not hidden.

Thanks,

Jef

 

[gilbert]

Hi,

As far as Hyperlink is concerned, it will direct the user to th
unhidden worksheet. You still can set the hyperlink but it won't sho
up when you click on the hyperlink.

I am not sure the alternative ways but based on your requirements, I a
sure it can be done using VBA. I suggest you re-post your question t
VBA section...

HTH.

Rgds,
Gilber

 

[muziq2]

Thanks Gilbert. I've reposted in the VBA forum.

-j