Alphabetically order sheet tabs??
 

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

Alphabetically order sheet tabs??
 

See attached link

www.cpearson.com/excel/sortws.htm


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553226

Alphabetically order sheet tabs??
 

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


--
Bro23
------------------------------------------------------------------------
Bro23's Profile: http://www.excelforum.com/member.php...o&userid=35564
View this thread: http://www.excelforum.com/showthread...hreadid=553226

Alphabetically order sheet tabs??
 

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553226

Alphabetically order sheet tabs??
 

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

Alphabetically order sheet tabs??
 

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

Alphabetically order sheet tabs??
 

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


--
Bro23
------------------------------------------------------------------------
Bro23's Profile: http://www.excelforum.com/member.php...o&userid=35564
View this thread: http://www.excelforum.com/showthread...hreadid=553226

Alphabetically order sheet tabs??
 

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 InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

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

Alphabetically order sheet tabs??
 

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


--
Bro23
------------------------------------------------------------------------
Bro23's Profile: http://www.excelforum.com/member.php...o&userid=35564
View this thread: http://www.excelforum.com/showthread...hreadid=553226

Alphabetically order sheet tabs??
 

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


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

Gord Dibben MS Excel MVP

Alphabetically order sheet tabs??
 

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


--
jonhunt
------------------------------------------------------------------------
jonhunt's Profile: http://www.excelforum.com/member.php...o&userid=35370
View this thread: http://www.excelforum.com/showthread...hreadid=553226

Alphabetically order sheet tabs??
 

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