Alternate selection methof for many tabs
 

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

Alternate selection methof for many tabs
 

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?

Alternate selection methof for many tabs
 

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

Alternate selection methof for many tabs
 

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?

Alternate selection methof for many tabs
 

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

Alternate selection methof for many tabs
 

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" 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
.. .
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

Alternate selection methof for many tabs
 

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
...
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


--

Dave Peterson

Alternate selection methof for many tabs
 

Dave,

Marvelous! Thank you.

Jack.

"Dave Peterson" schreef in bericht
...
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
...
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


--

Dave Peterson

Alternate selection methof for many tabs
 

Thanks from me also Dave

Gord

On Wed, 22 Aug 2007 21:11:29 -0500, Dave Peterson
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
...
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