Alphabetically order sheet tabs??

[Bro23]

Does anyone know how to alphabetically order the worksheet tabs at th
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

 

[Guest]

Hi Bro,

try the Chip Person module at

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

hope this helps
regards from Brazil
Marcelo

"Bro23" escreveu:

 

[Guest]

Copy the module to your workbook,

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

regards from Brazil

"Marcelo" escreveu:

 

[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

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

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 t
know how to do and I didn't understand the code either, but I followe
your instructions and it works wonderfully.

Jo

 

[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