Sheets in Workbook

[Guest]

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.

 

[Bernard Liengme]

I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window. If so, look here:
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

 

[Guest]

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

Bob M.

 

[JE McGimpsey]

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

 

[Guest]

Thanks,

Where would I enter the command to activate a sheet?

Bob M.

 

[JE McGimpsey]

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