Macro to alphabatize your sheet tabs?

[Jennifer]

I have a workbook created by someone else with about 50 different sheet tabs.
Each tab is a part number. I would like to organize them alphabetically but
it is quite a chore since there are so many. Is there a macro I can use that
will automatically put them in alphabetical order?

Thanks in advance for any help!

Jennifer

 

[Bob Phillips]

http://www.cpearson.com/excel/sortws.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Jennifer]

Wow, you're fast Thanks!

http://www.cpearson.com/excel/sortws.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

I only had to point you at the solution

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Traveller]

Perhaps I'm missing something, but I think all you have to do is right-click

 

[aaron.kempf]

Traveller

sorry but; Excel sucks balls. Only in Access can you right-click SORT
like that.

-Aaron

 

[Traveller]

Sorry, Aaron, I guess I wasn't clear. I meant to right-click on the worksheet
name tabs, which brings up a sub-menu. Then you choose your options normally
by left-clicking.

Jennifer is asking about sorting the tabs in the lower left-hand corner of
the sheet; that's where you right-click to bring up the sub-menues.

 

[Gord Dibben]

Traveller

Did you try your method?


Gord Dibben MS Excel MVP

 

[Bob Phillips]

Maybe in your Excel, but none that I have (97, 2000 or XP).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Traveller]

Absolutely. Works great for me (Excel 2003). I don't think I've done anything
special to my Excel. Maybe I'm still not explaining it very well. I'll check
the help files and see if I can come up with clearer instructions.

 

[dbahooker]

I dont see that functionality either

Maybe in your Excel, but none that I have (97, 2000 or XP).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[greaseman]

Aaron,

If you hate Excel so much, why are you wasting your time looking fo
that functionality?

Are you that stupid? In past postings, you've bragged of how great an
smart you are, but now you can't find a sorting functionality?

You're an idiot (to paraphrase what you've called other people in thi
forum)

 

[Traveller]

From what you all are writing, I think this feature might be specific to
Excel 2003. My help file gives this instruction for selecting all worksheets:

"Right-click a sheet tab, and then click Select All Sheets on the shortcut
menu (shortcut menu: A menu that shows a list of commands relevant to a
particular item. To display a shortcut menu, right-click an item or press
SHIFT+F10.)."

What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
Sheets is right above Tab Color. I was wrong about one thing: you don't even
have to Select All Sheets to sort them. Again, perhaps I'm getting this
option from an add-in that I've forgotten about!??

 

[Jim Cone]

You wouldn't happen to have "XL Extras" installed? ( tools | add-ins )
Available for free from http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA



"Traveller"
<[email protected]>
wrote in message
From what you all are writing, I think this feature might be specific to
Excel 2003. My help file gives this instruction for selecting all worksheets:

"Right-click a sheet tab, and then click Select All Sheets on the shortcut
menu (shortcut menu: A menu that shows a list of commands relevant to a
particular item. To display a shortcut menu, right-click an item or press
SHIFT+F10.)."

What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
Sheets is right above Tab Color. I was wrong about one thing: you don't even
have to Select All Sheets to sort them. Again, perhaps I'm getting this
option from an add-in that I've forgotten about!??

 

[Gord Dibben]

I would say definitely an add-in.

This feature is not Excel 2003 default.

Thanks for the update. I was thinking I missed something, which is not unheard
of<g>


Gord

 

[dbahooker]

greaseman

some excel dork was saying it was easy to alphabetize sheet names.

I wish that it was easy. That is one thing that I would have liked to
use; back in the stone age when I gave a crap about Excel.

In general; sorting and filtering in Access consists of right-click
sort and right-click filter.
it also supports much more powerful sorting and filtering through the
use of queries, views, sprocs.

Excel is for babies.. and I was correcting some mis-information.

-Aaron

 

[Traveller]

I checked and I sure do (at my age I can barely remember my name, let alone
the specifics of an add-in that I had forgotten about and had apparently been
taking for granted). If that is the source of my sorting power (together with
your Special Sort program, which I haven't forgotten about and which I
consider the best $14 I ever spent) then lets give credit where credit is
due.

By the way, I also highly recommend the free ASAP add-in, with something
like 300 features, some of which I couldn't live without.

So I apologize to everyone who wondered if one of us wasn't going crazy and
I give credit to Jim Cone for his great programming.

 

[Bob Phillips]

Nah, we all knew it was you going crazy <vbg>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[aaron.kempf]

greaseman

for the record-- I was correcting mis-information.

home-slice was saying you could right-click sort on the sheetnames and
sort them alphabetically.

CAN YOU DO THIS?

Eat shit greaser; I'm just making sure that people are aware that there
ARE better tools on the market.

TOO MANY CHIEFS AND NOT ENOUGH INDIANS.

-Aaron

 

[aaron.kempf]

yeah I'm just glad that greaseman didn't get all up on my back all over
nothing.

sounds like a great tool.

I just wish that MS would give this functionality.

I've been asking for MS to give us the ability to SORT FIELDNAMES --
like in a database-- alphabetically or in a query; and they apparently
don't think that it's important.

-Aaron