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

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 wrote:

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

Hi Dave

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

Cheers

Dave Peterson wrote:
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


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1