Mathew,

It is not possible to hyperlink to a hidden sheet.
Suggest you look into adding buttons someplace on the Introduction
worksheet or adding unformatted rectangles directly above the
sheet names. Each button/rectangle would run a macro
to unhide the sheet.

Jim Cone
San Francisco, USA


"MPB" wrote in message
...
Good afternoon all,

I have a workbook containing several worksheets.
I have included an Introduction Worksheet with Hyperlinks to each sheet.
However, I would like to be able to have the worksheets hidden (or very hidden),
except the Introduction sheet, until the Hyperlink is clicked, then that sheet is activated,
and when exited (by command button), this sheet becomes hidden again, and returns the user to
the Introduction sheet.

I hope I have expalained this well enough. I have some knowledge of VBA,( I have already set up the Command Buttons on the
worksheets).
Any help on this matter would be most appreciated.

Thank you

Mathew