Hi,

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. The INDEX page is always first, and it
contains a REFRESH macro that runs whenever new pages are added.