Order of the Worksheet tabs across the bottom of the screen

[Rich Mogy]

Hi All,
Is there a script that I could write that would put the worksheet tabs in
the order that I want them across the bottom of the screen.

Thanks in advance

Rich Mogy

 

[JE McGimpsey]

Sure. Just use the Move method. E.g.:

Sheets("SheetTheFirst").Move Before:=Sheets("SheetTheSecond")

 

[Pete_UK]

Chip Pearson has a few routines for sorting worksheets here:

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

Hope this helps.

Pete