How do I sort Worksheets by name?

We have lots of workbooks with multiple (over 100) spreadsheets. Is there a
quick way to sort them alphabetically by sheet name?
I tried to right click on one of the sheets, and there was no option to
sort.
I went through all the menus, with and without all sheets selected but can't
seem to find anything.

This seems like something that should be able to be done with a couple of
mouseclicks. Can it be done?

Excel 2000 and 2003

Thanks,
Mich

Hi

This is one of many functions offered by asap utilities' free add-in. You
can find more info at http://www.asap-utilities.com/

--
Andy.


"M Skabialka" <[email protected]> wrote in message
news:%[email protected]...
> We have lots of workbooks with multiple (over 100) spreadsheets. Is there
> a quick way to sort them alphabetically by sheet name?
> I tried to right click on one of the sheets, and there was no option to
> sort.
> I went through all the menus, with and without all sheets selected but
> can't seem to find anything.
>
> This seems like something that should be able to be done with a couple of
> mouseclicks. Can it be done?
>
> Excel 2000 and 2003
>
> Thanks,
> Mich
>

Only through VBA (macro)

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

Regards,

Peo Sjoblom

"M Skabialka" wrote:

> We have lots of workbooks with multiple (over 100) spreadsheets. Is there a
> quick way to sort them alphabetically by sheet name?
> I tried to right click on one of the sheets, and there was no option to
> sort.
> I went through all the menus, with and without all sheets selected but can't
> seem to find anything.
>
> This seems like something that should be able to be done with a couple of
> mouseclicks. Can it be done?
>
> Excel 2000 and 2003
>
> Thanks,
> Mich
>
>
>

M,

To sort worksheets alphabetically, you must use a macro.
I have written an Excel add-in (Excel Extras) that does that.
(it provides a sort option on the sheet tab right-click menu)

Other features are also included...
Creating a Table of Contents for the workbook
Inserting workbook information into the header and footers
Changing text to upper, lower, proper and Sentence case
More minor stuff.

It includes a Word.doc install/use file.

It is available -free- upon direct request.
Remove xxx from my email address.

Jim Cone
San Francisco, USA
[email protected]XX



"M Skabialka" <[email protected]> wrote in message
news:%[email protected]...
> We have lots of workbooks with multiple (over 100) spreadsheets.
> Is there a quick way to sort them alphabetically by sheet name?
> I tried to right click on one of the sheets, and there was no option to
> sort.
> I went through all the menus, with and without all sheets selected but can't
> seem to find anything.
>
> This seems like something that should be able to be done with a couple of
> mouseclicks. Can it be done?
> Excel 2000 and 2003
> Thanks,
> Mich

Exactly what I needed.
Thanks!

"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> Only through VBA (macro)
>
> http://www.cpearson.com/excel/sortws.htm
>
> Regards,
>
> Peo Sjoblom
>
> "M Skabialka" wrote:
>
>> We have lots of workbooks with multiple (over 100) spreadsheets. Is
>> there a
>> quick way to sort them alphabetically by sheet name?
>> I tried to right click on one of the sheets, and there was no option to
>> sort.
>> I went through all the menus, with and without all sheets selected but
>> can't
>> seem to find anything.
>>
>> This seems like something that should be able to be done with a couple of
>> mouseclicks. Can it be done?
>>
>> Excel 2000 and 2003
>>
>> Thanks,
>> Mich
>>
>>
>>