Excel has a built-in list of sheets that you might prefer using. Look at
the bottom left corner of the screen, right above the "START" button. There
you will see left and right arrows that you normally use to scroll the sheet
tabs. Right-click anywhere within these arrows. This pops up a listing of
the sheets in the current workbook. In your case, with 98 sheets, notice
that the last listing is "More sheets". Click on that. That brings up a
scrollable listing of all sheets. Click on any sheet name and that sheet
will become the active sheet. HTH Otto
"hardeep.kanwar" wrote in message
...

Hi! Experts

I have Workbook which have 98 Sheets include a "UNIQUE LIST" Which have
Names of the Sheets.

Now i want to insert Hyperlinks in the "UNIQUE LIST" to other Sheets.

Ex:

If i Click on CZ001 it take me to CZ001 Sheet. If i click on WZ009 it
take me to WZ009 and so on.

I knew how to insert the Hyperlinks but i want any Formula or Code that
will do me with in a Mintues.

MY Second Question is:

Say i Click on CZ001 it take me to CZ001 and When i click on A1 of
Sheet!CZ001 it take me to "UNIQUE LIST"

If i Click on WZ009 in "UNIQUE LIST" it take to me Sheet!WZ009, when i
Click on A1 of Sheet!WZ009 it take me to "UNIQUE LIST"

Is this Possible

Thanks in Advance

Hardeep Kanwar


--
hardeep.kanwar
------------------------------------------------------------------------
hardeep.kanwar's Profile:
http://www.thecodecage.com/forumz/member.php?userid=170
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=107000