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!