This one's got me puzzled. Nothing I think seems to work.

You could put the name of the sheet in a cell without a
hyperlink; the user could then click on the cell to activate
a macro that would detect the cell that was clicked, get
the contents of that sheet, unhide the sheet and jump to
it. The only problem is that I can't find a Click event for
a cell, so that doesn't work. (Besides, how would you
hide the sheet again afterward?)

You could put a command button in the cells that
represent a hidden sheet, and connect code to each
button to do what you want. But how do you make
the button's contents or caption fully dynamic?

Is there a way to make the URL point to the execution
of a VBA module rather than to an internal sheet? I
see that happening in MSIE; maybe there's a way to
do it in VBA/Excel, too.

--- "Squeaky" wrote:
I have a workbook that can contain anywhere from
5-20 worksheets. On the first page (INDEX) I have
a macro that will display all the names of the
spreadsheets. I have formulas that divide the
speadsheets between the hidden and the unhidden
spreadsheets and places them in their own
columns. Using the hyperlink function each
spreadsheet name then displays as a hyperlink,
and when I click on it, it will take me to that
spreadsheet. What I want is to be able to click the
hyperlink to a hidden speadsheet, have it unhide,
and go to it. It must be dynamic because the
spreadsheet names can change or vary, and the
amount of spreadsheets vary.