links to worksheets

S

Soccer boy

My question is this. I have alot of worksheets in my workbook, to many to
actually scroll through to find the one you want quickly. so i wanted to
make an index or directory on one worksheet with links to the other, kinda
like a Table of Contents. Is this possible.
 
P

Pimamedic

Yes it is take the first worksheet and make links to cell A1 in each sheet I
labeled this sheet Master for a table of contents sheet.
 
D

Dave Peterson

You could create a list of hyperlinks on a worksheet that you treat as a
table of contents.

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.

=======
If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top