Sheets in Workbook
 

I have a workbook with multiple sheets which have been renamed. Is there a
way to arrange the named sheets in alphabetical on the tool bar?

Bob M.

Sheets in Workbook
 

I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window. If so, look he
http://www.cpearson.com/excel/sortws.aspx
Need help with VBA? See David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"robert morris" wrote in message
...

I have a workbook with multiple sheets which have been renamed. Is there
a
way to arrange the named sheets in alphabetical on the tool bar?

Bob M.

Sheets in Workbook
 

Sorry, I did mean the row of tabs. Thanks for the link. I wil check there.

Bob M.

"Bernard Liengme" wrote:

I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window. If so, look he
http://www.cpearson.com/excel/sortws.aspx
Need help with VBA? See David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"robert morris" wrote in message
...

I have a workbook with multiple sheets which have been renamed. Is there
a
way to arrange the named sheets in alphabetical on the tool bar?

Bob M.

Sheets in Workbook
 

Why do you hope that?

The worksheet tabs ARE just a toolbar:

Commandbars("Workbook tabs")

You can activate sheet "Sheet3" with

Commandbars("Workbook tabs").Controls("Sheet3").Execute

In article ,
"Bernard Liengme" wrote:

I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window.

Sheets in Workbook
 

Thanks,

Where would I enter the command to activate a sheet?

Bob M.

"JE McGimpsey" wrote:

Why do you hope that?

The worksheet tabs ARE just a toolbar:

Commandbars("Workbook tabs")

You can activate sheet "Sheet3" with

Commandbars("Workbook tabs").Controls("Sheet3").Execute

In article ,
"Bernard Liengme" wrote:

I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window.

Sheets in Workbook
 

Not saying you would, necessarily - that's only one way to activate. A
more straightforward way would be

Sheets("Sheet1").Activate

But you *could* enter either in the Immediate Window of the VBE. Or you
could use either command in a macro.

I was just pointing out that the worksheet tabs were indeed a toolbar...

In article ,
robert morris wrote:

Where would I enter the command to activate a sheet?