can i link a cell to jump to a worksheet?

[mike]

Hello,

i have a list on the first sheet that is a list of the
names identical to the names of wrkshts.

Is it possible to click on hte cell with the name and
have it jump to the worksheet with the name chosen?
If so, How??

Thanks!

 

[JE McGimpsey]

Insert a hyperlink in the cell. make the destination a cell in the
appropriate worksheet.

Alternatively, look at David McRitchie's BuildTOC macro, which creates
such a Table of Contents with hyperlinks:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[John Green]

You can hook into an event such as the BeforeDoubleclick. Enter the following code into the ThisWoorkbook module of the workbook:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Sheets(Target.Value).Activate
End Sub

Doubleclicking a cell will then jump to the name of the worksheet in the cell.

However, it is easier to right click the navigation buttons at the bottom left of the worksheet and choose the sheet you want.