Order of the Worksheet tabs across the bottom of the screen
 

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

Order of the Worksheet tabs across the bottom of the screen
 

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

Sheets("SheetTheFirst").Move Befo=Sheets("SheetTheSecond")

In article ,
"Rich Mogy" wrote:

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

Order of the Worksheet tabs across the bottom of the screen
 

Chip Pearson has a few routines for sorting worksheets he

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

Hope this helps.

Pete

On Jan 16, 12:50*am, "Rich Mogy" wrote:
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