C Chas Nov 5, 2003 #1 Is there a way in Excel XP to get the worksheet tabs to sort themselves? E.g. alphabetically or by date? Thanks!
Is there a way in Excel XP to get the worksheet tabs to sort themselves? E.g. alphabetically or by date? Thanks!
C Chip Pearson Nov 5, 2003 #2 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 (e-mail address removed)
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 (e-mail address removed)
C Chip Pearson Nov 5, 2003 #4 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 (e-mail address removed)
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 (e-mail address removed)
