Working Between Worksheets

  • Thread starter Thread starter jrk7520
  • Start date Start date
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
 
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
 
You can do this using the HYPERLINK function - just describe what you
want to do in more detail.

Pete
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Problem with hidden rows automatically unhiding 2
worksheet renames - specific 0
Copy Cells from multiple Worksheets in same workbook. 2
summing across worksheets conditionally and being able to copy for 4

Back
Top