Sorting worksheet tabs

Chas · Nov 5, 2003

Is there a way in Excel XP to get the worksheet tabs to
sort themselves? E.g. alphabetically or by date?

Thanks!

Chip Pearson · Nov 5, 2003

Chas,

You can use a VBA procedure to do this. See
www.cpearson.com/excel/sortws.htm for details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]

Chas · Nov 5, 2003

Thanks Chip, This is fantastic. I presume VBA is the
only way?

Chip Pearson · Nov 5, 2003

Chas,

Yes, VBA is the only way, other than manually moving around the sheets
yourself. Excel has no built-in way to sort the sheets.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]