Alternate selection methof for many tabs

[Phil Smith]

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

 

[David Hilberg]

Using that
little scroll bar to choose various worksheets within is a pain in the but.

If you right-click the tiny arrows, you get a clickable list of the
first 15 sheets, and you can click "More Sheets" to get the whole list.
Or is that what you already were doing?

 

[Gord Dibben]

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/micr...464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25

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

 

[Phil Smith]

Nope. That is a shortcut I did not know about. Thanx.

 

[Jack Sons]

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]

The bar in question is the Status Bar.

I don't know how to dock the toolbar onto the status bar as you ask.

Not enough skills in VBA.

You can drag it down there and dock it but when you close then re-open Excel it
will float again.

Perhaps Dave or Debra can assist?

That's why I personally like Bob's Browsesheets macro. Just stick a button on a
Toolbar and click the button to navigate the sheets.


Gord

 

[Dave Peterson]

Add one line:

With cb
.Visible = True
.Position = msoBarBottom '<-- Added

 

[Jack Sons]

Dave,

Marvelous! Thank you.

Jack.

Add one line:

With cb
.Visible = True
.Position = msoBarBottom '<-- Added

 

[Gord Dibben]

Thanks from me also Dave

Gord

Add one line:

With cb
.Visible = True
.Position = msoBarBottom '<-- Added