View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CP CP is offline
external usenet poster
 
Posts: 64
Default 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?