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.

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.

"Soccer boy" wrote:

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.

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 he
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.)

Soccer boy wrote:

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.

--

Dave Peterson