display order of worksheets

[carf4F]

I would like to have multiple worksheets in the same book displayed in
a predetermined order whichever worksheet I work on. How can I do this?

 

[Bob Phillips]

You can easily move theme around from code say in the workbook open. Is that
what you mean?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[FennisDuck]

what is the code to move the worskheets 1,2,3 etc
I am NOT the original poster but am very intrested thanks to original poster
and Bob Philips

 

[Bob Phillips]

To organise say sheets 1,2,3 to 3,2,1

Worksheets(2).Move after:=Worksheets(3)
'sheet index 2 has now become sheet index 3, so
Worksheets(1).Move after:=Worksheets(3)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[David McRitchie]

To sort the worksheet tabs into alphabetical order
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

You can modify the final results after sorting to move individual
sheets to the front.
http://www.mvps.org/dmcritchie/excel/sheets.htm
but for a very few exceptions the only real order that works
when you have a lot of sheets is alphabetical. And you can
change the names of the sheet tabs so that they will sort
into best order when sorted alphabetically with a macro.