display order of worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carf4F@gmail.com - 07 Sep 2006 06:44 GMT

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?

Reply to this Message

Bob Phillips - 07 Sep 2006 09:13 GMT

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

Signature

HTH

Bob Phillips

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

> 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?

Reply to this Message

FennisDuck - 10 Sep 2006 20:03 GMT

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

> You can easily move theme around from code say in the workbook open. Is
> that
> what you mean?
>
>> 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?

Reply to this Message

Bob Phillips - 11 Sep 2006 00:24 GMT

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)

Signature

HTH

Bob Phillips

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

> 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
[quoted text clipped - 5 lines]
> >> 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?

Reply to this Message

David McRitchie - 11 Sep 2006 08:36 GMT

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> 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
[quoted text clipped - 6 lines]
> >> 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?

Reply to this Message