Hi,

I want to hyperlink to a hidden worksheet in the same workbook. An
ideas?

Everything works fine when the sheet that I want the hyperlink to jum
to is not hidden. I use the following function.

=HYPERLINK("[filename]'sheetname'!A1","display name")

When the user clicks on this cell the other sheet is displayed.

However, I want the destination sheet to be hidden until the use
clicks on the cell containing the hyperlink. Then I want the sheet t
automatically unhide and display. Then when the user clicks o
another workbook the destination sheet should then revert to hidden.

Is this possible?

Thanks,

Jef

--
Message posted from http://www.ExcelForum.com