List box or form

C

CP

I have an excel file which contains about 30 sheets - I always have trouble
scrolling through them to find my data, is there a way of adding a list
box/form that would always be on top allowing me to have links to the pages?
 
F

FSt1

hi.
Try this. at the far left bottom of the excel window, right click the
sheet(tab) navigatior. you should get a popup showing the sheets. but in your
case (with 30 sheets) at the bottom of the popup, it should say "more
sheets". clicking that will popup a activations form with all the sheet in
the book. click the desired sheet name to go to that sheet.

Regards
FSt1
 
D

Dave Peterson

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.
 
Top