Hyperlink from one cell to another

L

Lexus

Does anyone know how to make it so a user can click on an Excel cell and be
hyperlinked to another cell on another tab?

Thanks!
 
P

paul

have you tried looking at help for hyperlinks?
=hyperlink("[book1]Sheet2!A1","click here")
Help says
You can create hyperlinks within a worksheet to jump from one cell to
another cell. For example, if the active worksheet is the sheet named June in
the workbook named Budget, the following formula creates a hyperlink to cell
E56. The link text itself is the value in cell E56.

=HYPERLINK("[Budget]June!E56", E56)

To jump to a different sheet in the same workbook, change the name of the
sheet in the link. In the previous example, to create a link to cell E56 on
the September sheet, change the word "June" to "September."
 
D

Don Guillett

in a cell use ctrl+k>place in this document>change text to suit

OR use a double_click (or right click) event in the sheet code.
right click sheet tab>view code>copy/paste this

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Address = "$A$9" Then _
Application.Goto Sheets("sheet2").Range("a2")
End Sub
 
Top