Arrange worksheets (the way i want to)

[kingpeejay]

I have a workbook with 8 worksheets. What i want to do is to arrange the last 5 worksheet in an order i want to. The last 5 worksheets are named: sheetA, sheetB, sheetC, sheetD, sheetE. I want it to be in this sequence: sheetD, sheetA, sheetC, sheetB, sheetE

Thanks in advance!

[Special-K]

Click on the worksheet tab name and just drag it where you want

[kingpeejay]

The number of worksheets above is just an example. Actualy, my workbook contains at least 20 worksheets. So, i prefer macro to do this. Plus, this is just 1 part of what i have to do

[MickG]

Place all you sheet Names In Desired order in Column "A".
Run Code.

Please Login or Register  to view this content.

Regards Mick

[kingpeejay]

Il put it in a separate sheet?