Hyperlink to Hidden Sheet

  • Thread starter Thread starter muziq2
  • Start date Start date
M

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
 
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
 
Back
Top