Order of the Worksheet tabs across the bottom of the screen

Rich Mogy · Jan 16, 2009

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 · Jan 16, 2009

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

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

Pete_UK · Jan 16, 2009

Chip Pearson has a few routines for sorting worksheets here:

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

Hope this helps.

Pete

Order of the Worksheet tabs across the bottom of the screen

Rich Mogy

JE McGimpsey

Pete_UK