I have set up a spreadsheet that will have numerous sheets and would like to
set the first page up as a navigation page - can someone help?!

Consider using hyperlinks.

You can set up hyperlinks to take you to individual worksheets or to
specific tables on the worksheets. Just follow the Wizard and specify
hyperlink to "a place in this document".
--
Gary''s Student - gsnu200737


"slavenp" wrote:

I have set up a spreadsheet that will have numerous sheets and would like to
set the first page up as a navigation page - can someone help?!

slavenp wrote:

I have set up a spreadsheet that will have numerous sheets and would like to
set the first page up as a navigation page - can someone help?!

--

Dave Peterson

Oops...

If you rightclick on the VCR like controls (to the left of the worksheet tabs),
you'll see a list of worksheets in that workbook.

Other options:

Maybe you could use David McRitchie's Build Table of Contents to get the list
and the hyperlinks all at once:
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.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

slavenp wrote:

I have set up a spreadsheet that will have numerous sheets and would like to
set the first page up as a navigation page - can someone help?!

--

Dave Peterson