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!

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!

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!