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

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

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

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

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


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

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

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