Alphabetically order sheet tabs??

Does anyone know how to alphabetically order the worksheet tabs at the bottom of the workbook??

See attached link

www.cpearson.com/excel/sortws.htm

I dont know how to read that.
Can you please put this in simpler terms.

It's VBA code

Copy from "Sub SortWorksheets() " to "end Sub" then go to excel and press alt F11. Then click on insert then Module.

Paste code and then close Visual basic editor. Next press Alt F8 amd select Sortworksheets

Hi Bro,

try the Chip Person module at

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

hope this helps
regards from Brazil
Marcelo

"Bro23" escreveu:

>
> Does anyone know how to alphabetically order the worksheet tabs at the
> bottom of the workbook??
>
>
> --
> Bro23
> ------------------------------------------------------------------------
> Bro23's Profile: http://www.excelforum.com/member.php...o&userid=35564
> View this thread: http://www.excelforum.com/showthread...hreadid=553226
>
>

Copy the module to your workbook,

select the module, copy go to excel, press ALT + F11 and paste it

regards from Brazil

"Marcelo" escreveu:

> Hi Bro,
>
> try the Chip Person module at
>
> http://www.cpearson.com/excel/sortws.htm
>
> hope this helps
> regards from Brazil
> Marcelo
>
> "Bro23" escreveu:
>
> >
> > Does anyone know how to alphabetically order the worksheet tabs at the
> > bottom of the workbook??
> >
> >
> > --
> > Bro23
> > ------------------------------------------------------------------------
> > Bro23's Profile: http://www.excelforum.com/member.php...o&userid=35564
> > View this thread: http://www.excelforum.com/showthread...hreadid=553226
> >
> >

I would jus like to know the simplest way possible because i am not an avid excel user and do not understand complicated things in excel. Please explain the SIMPLEST way step by step and I will be very pleased with ur help

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project by name and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo


Gord Dibben MS Excel MVP

On Wed, 21 Jun 2006 11:07:05 -0500, Bro23
<[email protected]> wrote:

>
>I would jus like to know the simplest way possible because i am not an
>avid excel user and do not understand complicated things in excel.
>Please explain the SIMPLEST way step by step and I will be very pleased
>with ur help

Gord Dibben MS Excel MVP

is there any different way to do it beside that^^^