Gord,

Debras solution works fine, but when I open Excel I would like to apear the
floating sheet navigation bar automatically (fixed) in the bar below the
sheet tabs. I don't know the name of it, it seems to be an extra bar when I
push the navigation bar to the lowest place on screen that is possible.

Even nicer would be one bar lower, that is the light colored bar just above
the lowest bar (blue, it contains the start button and the minimized
workbooks).

Is that possible?

Jack Sons
The Netherlands



"Gord Dibben" <gorddibbATshawDOTca schreef in bericht
...
Phil

How about a sheet navigation bar from Debra Dalglesih?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro?

See this google search result. All one line for the URL

http://groups.google.com/group/micro...c19464f875bd25

To sort the sheets, if you want them sorted, see Chip Pearson's site for
code.

http://www.cpearson.com/excel/sortws.htm


Gord Dibben MS Excel MVP

On Wed, 22 Aug 2007 14:31:08 -0700, Phil Smith wrote:

I have a workbook that will have about 30 or so sheets. Using that
little scroll bar to choose various worksheets within is a pain in the
but.

1) Is there a way to sort these tabs alphabetically and automatically?

2) Is there any way to pull up a list of them where one can be selected
from that list?

Thanx