I have a list of numbers that coincide with the sheet numbers... i want to be
able to click on the number on my first sheet and have it open up the sheet#
that i click on... is this possible and if so what function do i use to
direct it to do this??

Right-click the cell containing the number of the tab you wish to go to
(open).
Choose 'Hyperlink' from the menu.
In the dialog box click 'Place in this document' on the left.
Select the sheet from the list.

George Gee


"Tim Twilley" <Tim wrote in message
...
I have a list of numbers that coincide with the sheet numbers... i want to
be
able to click on the number on my first sheet and have it open up the
sheet#
that i click on... is this possible and if so what function do i use to
direct it to do this??

You can use hyperlinkplace in this document on your list in sheet1 to jump to
the other sheets.

Question...........how will you get back to sheet1 with the list of numbers to
go to other sheets?

You may just need some code you assign to a button which is accessible from any
sheet.

Did you know that if you right-click on the navigation arrows at bottom left
side of sheet tabs you get a list of 15 sheets and "more sheets"?


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 14:08:03 -0700, Tim Twilley <Tim
wrote:

I have a list of numbers that coincide with the sheet numbers... i want to be
able to click on the number on my first sheet and have it open up the sheet#
that i click on... is this possible and if so what function do i use to
direct it to do this??