Hyperlink to Hidden Sheet

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

You'll need a new app to open this about link 1
Hyperlink problems 1
Combining two sheets of data into one and sorting by value - using macros 5
Need to have an index sheet but all other sheets should be hidden 1
Hyperlinks to many Sheets within a Workbook 5
Using Hyperlink Function 5
HYPERLINK - Jump to another sheet in the same workbook 3
Hyperlink to cell within a sheet breaks when cells are sorted 1

Top