hyperlink based on user's input

  • Thread starter Thread starter izbryte
  • Start date Start date
I

izbryte

I have a workbook with several worksheets. Is it possible to jum
(hyperlink) to a specific worksheet by entering its name in a cell?

For example,
i have a workbook with worksheets A,B,C,D,E. If the user enters "D" i
a specific cell, I'd like that worksheet to open.

Does that make sense
 
go to tools->macro->visual basic editor. double click sheet1 ,sheet
.... and paste the below code.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo interrupt
Worksheets(Target.Value).Select
interrupt:
End Su
 
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
Code to change part of a formula across worksheets 4
Help with hyperlinks 2
Loop to hide sheet based on cell 1
Grey Fill for all cells that contain a certain string in hyperlinkaddress 4
hyperlink to changing field depending on input 6
Hyperlink with Code 6
Selection based on partial input 1

Back
Top