Alphabetically order sheet tabs??

[Bro23]

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

[VBA Noob]

See attached link

www.cpearson.com/excel/sortws.htm

[Bro23]

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

[VBA Noob]

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

[Marcelo]

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

[Marcelo]

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

[Bro23]

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]

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

[Bro23]

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

[Gord Dibben]

Yes

Do it manually by dragging the sheet tabs into the order you want.

It is not difficult to copy the code from Chip's site to a module in your
workbook as I have explained.

You can't break anything by trying on a copy of your original workbook.

Put in a little effort and you will soon learn to deal with VBA.


Gord

On Wed, 21 Jun 2006 12:59:56 -0500, Bro23
<[email protected]> wrote:

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

Gord Dibben MS Excel MVP

[jonhunt]

Gord,

Your instructions were great. I thought this would be something cool to know how to do and I didn't understand the code either, but I followed your instructions and it works wonderfully.

Jon

[Gord Dibben]

Thanks for the feedback Jon

You're on your way now...........keeo at it.

By opening the world of VBA you expand the uses of Excel and make life so much
easier.

The Macro Recorder can be your friend.


Gord

On Wed, 21 Jun 2006 14:04:45 -0500, jonhunt
<[email protected]> wrote:

>
>Gord,
>
>Your instructions were great. I thought this would be something cool to
>know how to do and I didn't understand the code either, but I followed
>your instructions and it works wonderfully.
>
>Jon