Macro to produce Hyperlinks

[franklin85]

Hello people,

I have a query regarding hyperlinks. I have a summary page of around 90
organisations, each of which has its own tab within the work book.

I was wondering if there was a macro or something which would save me having
to go through the list of organisations one by one and creating a hyperlink
individually to its related sheet. The organisation names all are the same
as thier related tab name within the work book.

Many thanks for your help

Franklin85

 

[Dave Peterson]

David McRitchie has some code that creates a table of contents (using
hyperlinks):
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site.

 

[franklin85 via OfficeKB.com]

Hi Dave

Thanks for that, Debra's navigater tool worked perfectly. Should save me
loads of time in the long run.

Cheers

David McRitchie has some code that creates a table of contents (using
hyperlinks):
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site.

Hello people,

[quoted text clipped - 9 lines]

Franklin85