the 100 dollar question

[D_Zsol]

I have already had 2 mod's answer to this, neither of them were right yet and
I am running out of options on how to accomplish this task.


I want to take a workbook containing around 20 sheets, create a new sheet
within that workbook and hyperlink or something to that effect all of the
underlying sheets to the 'master sheet' so my supervisor can just click on
the name of the given chemcial and it will take him directly to the sheet,
rather than having to tab through all of the sheets to find what he needs.
Any ideas?

Thanks for the time.

 

[Bernard Liengme]

Are we to understand that each sheet is named after a chemical?
So if there is a sheet called Benzene you want that word on the mater sheet
to be linked to the Benzene worksheet?

 

[Dave Curtis]

So why is a hyperlink from the master sheet to another sheet called benzene
(or something) not suitable?
It's easy enough to do, so what functionality are you still missing with it?


Dave

url:http://www.ureader.com/msg/10296999.aspx

 

[PBezucha]

As I understand your problem, the solution may be in generating the following
sub and providing a proper shortkey for it:

Sub GoToSheet()
'Goes to the sheet with the name in a highligted cell.
Dim SheetName As String, MB As Long
On Error GoTo ErrExit
SheetName = Selection.Value
Worksheets(SheetName).Activate
Exit Sub
ErrExit:
MB = MsgBox("Worksheet " & SheetName & " is not in active workbook", _
vbCritical, "Go to sheet")
End Sub

Another proper amendment would be the automatic generation of sheets
(chemicals) list in the mother worksheet.