hyperlink based on user's input
 

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

--
izbryt

-----------------------------------------------------------------------
izbryte's Profile: http://www.excelforum.com/member.php...fo&userid=1674
View this thread: http://www.excelforum.com/showthread.php?threadid=32011

hyperlink based on user's input
 

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

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=32011

hyperlink based on user's input
 

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"izbryte" schrieb im Newsbeitrag
...

I have a workbook with several worksheets. Is it possible to jump
(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"
in
a specific cell, I'd like that worksheet to open.

Does that make sense?


--
izbryte


---------------------------------------------------------------------
---
izbryte's Profile:
http://www.excelforum.com/member.php...o&userid=16740
View this thread:
http://www.excelforum.com/showthread...hreadid=320110