List box or form
 

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?

List box or form
 

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

"CP" wrote:

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?

List box or form
 

Ok thats a great - is there any way to have it permanently there ?

"FSt1" wrote:

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

"CP" wrote:

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?

List box or form
 

Ignore my last entry - the answer was in "hyperlinked drop down entries"
posted below

List box or form
 

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.

CP wrote:

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?

--

Dave Peterson