Working Between Worksheets

J

jrk7520

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
 
F

FSt1

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
 
P

Pete_UK

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

Pete
 
G

Gord Dibben

If the sheet is hidden through code or through Format>Sheet>Hide 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
 
Top