sheets in alphabetical order

[tkincaid]

I want to put my sheets in alphabetical order, except I want to put one sheet
first and one last that would not be in alphabetical order. How do I do this.

 

[Gary''s Student]

First sort them all:

http://www.cpearson.com/excel/sortws.aspx

and then manually drag the desired first sheet to the left and the desired
last sheet to the left.

 

[Chip Pearson]

The code on that page has an option for starting the sort at the
second (or any subsequent) sheet, but for a one-time sort, it is
probably easier to sort them all.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)