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!

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


In article ,
"mike" wrote:

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!

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.

--

John Green - Excel MVP
Sydney
Australia


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