How do I sort tabs automatically?!

[Shiperton Henethe]

Excel2002/Win2K

Hi

Anyone know an automatic way to sort the tabs (of sheets within a workbook)
into alphabetical order?

Obviously one can drag them manually but when you have
a lot of tabs (and you cant see them all on one screen)
this becomes a damned nuisance.

Is there a way to do it automatically using some tool?


Ship
Shiperton Henethe

 

[Frank Kabel]

Hi
have a look at the following site for some code to do this
http://www.cpearson.com/excel/sortws.htm

 

[Shiperton Henethe]

That looks promising but...
(please forgive this VBA newbie question!)
but how on earth do I get that code to run?

I've never yet understood how to write/run macros etc!

- Do I have to create a separate macro file somewhere?
- How to I run it on the Worksheet I'm in?!

Thanks


Ship

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for getting started with macros.

In general try the following:
- open your workbook
- Hit ALT + F11 to open the VBA editor
- Create a new module (right click in the explorer window on your
project and choose 'insert module')
- paste the code
- close the editor and save your workbook

Now you can start the macro from the menu 'Tools-Macro-Macros'

 

[JE McGimpsey]

See David McRItchie's Getting Started with Macros:

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

 

[RagDyer]

Are you aware of the drop down (pop-up) menu that XL provides, which
displays all the sheets of a WB ?

Right click on any of the directional arrows that are to the left of the
sheet names.
This gives you a list of about 15 sheet names with the option to expand to
an infinite scrolling list of all the sheets in the WB.

This list is in the order that the sheets are in the WB.
Any sorting must be done by manually moving the sheets within the WB ... If
this isn't good enough you can try David McRitchie's TOC.

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

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





That looks promising but...
(please forgive this VBA newbie question!)
but how on earth do I get that code to run?

I've never yet understood how to write/run macros etc!

- Do I have to create a separate macro file somewhere?
- How to I run it on the Worksheet I'm in?!

Thanks


Ship

 

[Jim Cone]

Shiperton,

You may have an interest in the my Excel add-in (utility) that
sorts sheets with the click of a button. It includes several other
features including the ability to quickly add or remove data in the
headers and footers and modify fonts.
The add-in (Excel Extras) is available - free - upon direct request.
It comes with a Word.doc install/use file.
Remove "xxx" from my email address.

Regards,
Jim Cone
San Francisco, Ca
(e-mail address removed)

Excel2002/Win2K

 

[Shiperton Henethe]

Interesting...

Where do I find this drop-down/pop-up list?

Ship

 

[RagDyeR]

Did you not notice this ?

<<"Right click on any of the directional arrows that are to the left of the
sheet names.">>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





Interesting...

Where do I find this drop-down/pop-up list?

Ship