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

Phil Smith wrote:
> 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?

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 <(E-Mail Removed)> 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

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




David Hilberg wrote:
> Phil Smith wrote:
>
>> 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,

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
news:(E-Mail Removed)...
> 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 <(E-Mail Removed)> 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
>

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

On Thu, 23 Aug 2007 00:40:44 +0200, "Jack Sons" <(E-Mail Removed)> wrote:

>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
>news:(E-Mail Removed)...
>> 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 <(E-Mail Removed)> 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
>>
>

Add one line:

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

Jack Sons wrote:
>
> 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
> news:(E-Mail Removed)...
> > 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 <(E-Mail Removed)> 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
> >

--

Dave Peterson

Dave,

Marvelous! Thank you.

Jack.

"Dave Peterson" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Add one line:
>
> With cb
> .Visible = True
> .Position = msoBarBottom '<-- Added
>
> Jack Sons wrote:
>>
>> 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
>> news:(E-Mail Removed)...
>> > 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 <(E-Mail Removed)>
>> > 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
>> >
>
> --
>
> Dave Peterson

Thanks from me also Dave

Gord

On Wed, 22 Aug 2007 21:11:29 -0500, Dave Peterson <(E-Mail Removed)>
wrote:

>Add one line:
>
> With cb
> .Visible = True
> .Position = msoBarBottom '<-- Added
>
>Jack Sons wrote:
>>
>> 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
>> news:(E-Mail Removed)...
>> > 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 <(E-Mail Removed)> 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
>> >