Is there a way to connect a cell in a worksheet to another worksheet that is
hidden. Example i want to be able to type in a 1 for a certain cell and be
taken to worksheet 1 or a 2 and be taken to worksheet 2

hi.
may be an easier way.
right click the sheet navigator in the lower left of the sheet. a pop up
will appear with all of your sheets on it. click one to go to it.

Regards
FSt1

"jrk7520" wrote:

Is there a way to connect a cell in a worksheet to another worksheet that is
hidden. Example i want to be able to type in a 1 for a certain cell and be
taken to worksheet 1 or a 2 and be taken to worksheet 2

You can do this using the HYPERLINK function - just describe what you
want to do in more detail.

Pete

On Jun 26, 9:26*pm, jrk7520 wrote:
Is there a way to connect a cell in a worksheet to another worksheet that is
hidden. *Example i want to be able to type in a 1 for a certain cell and be
taken to worksheet 1 or a 2 and be taken to worksheet 2

If the sheet is hidden through code or through FormatSheetHide you will need
VBA event code to unhide and activate the sheet.

Hidden sheets won't show on the nav'n bar and you cannot hyperlink jump to a
hidden sheet.


Gord Dibben MS Excel MVP

On Thu, 26 Jun 2008 13:26:00 -0700, jrk7520
wrote:

Is there a way to connect a cell in a worksheet to another worksheet that is
hidden. Example i want to be able to type in a 1 for a certain cell and be
taken to worksheet 1 or a 2 and be taken to worksheet 2