sheet tabs in alphabetical order

[carsto]

Can you write a macro that puts the sheet tabs in alphabetical order?
with two exceptions:
Sheet named Cover is in position1 (it also happens to be sheet1)
Sheet Report Verifier is in position2 (it also happens to be sheet2)

then the remaining sheets are alphabetical by sheet name

[Leith Ross]

Hello Carstowal,

Chip Pearson has a page about sorting worksheets in a variety of ways using VBA. He gives you the code, explainations, and tips at this site.

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

Sincerely,
Leith Ross

[antoka05]

Try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

[carsto]

Thank you both