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.

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?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"D_Zsol" <(E-Mail Removed)> wrote in message
news1AE7551-E3C9-446D-B5A9-(E-Mail Removed)...
>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.

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.
--
Petr Bezucha


"Bernard Liengme" wrote:

> 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?
> --
> Bernard V Liengme
> Microsoft Excel MVP
> http://people.stfx.ca/bliengme
> remove caps from email
>
> "D_Zsol" <(E-Mail Removed)> wrote in message
> news1AE7551-E3C9-446D-B5A9-(E-Mail Removed)...
> >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.
>
>
>