selecting w/sheet by click on a cell

[colleen]

I have a work book with a lot of sheets, I wonder is it possible to have the first sheet have the names of all the tabs of each worksheet so all i do is click or press enter of the tab name on the first sheet (a sort of table of content) it will automatically go to that sheet..hmmm thk c.

[willlobb]

You need to name cell A1 in each sheet that you have, by the name of the sheet. then in your first sheet type all the names of the sheets in separate cells and on each one, right-click and add Hyperlink. Click on Place In This Documen, and select the cells from the list that you have named. Hope this helps.
Will

[Derek]

Hi Colleen
Try this:

Right click your sheet tab, left click View Code and paste in this event macro code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Sheets(Target.Value).Select
End Sub

Type your sheet names on Sheet1 (or whatever). When you double click the sheet name the macro will select that sheet.

Hope this helps
regards
Derek

[Derek]

Hi Colleen
Try this:

Right click your sheet tab, left click View Code and paste in this event macro code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Sheets(Target.Value).Select
End Sub

Type your sheet names on Sheet1 (or whatever). When you double click the sheet name the macro will select that sheet.

Hope this helps
regards
Derek

[colleen]

thanks a lot both of u nice guys for that speedy response..works a charm...colleen