Hyperlink from one cell to another
 

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!

Hyperlink from one cell to another
 

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."




--
paul
remove nospam for email addy!



"Lexus" wrote:

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!

Hyperlink from one cell to another
 

in a cell use ctrl+kplace in this documentchange text to suit

OR use a double_click (or right click) event in the sheet code.
right click sheet tabview codecopy/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
--
Don Guillett
SalesAid Software

"Lexus" wrote in message
...
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!