MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Workbook Printing Order

Posted by Robert Johnston on August 10, 2001 9:41 AM

I have a workbook with several worksheets (WS1, WS2, WS3...). When I print the "entire workbook" the printout comes in an order different than the worksheets (tabs) are ordered in the workbook (WS2, WS1, WS3...). How can I force the print command to use the order of the worksheet tabs.

Posted by Cory on August 10, 2001 10:30 AM

Not an answer, but...

That's really odd. I can't figure out how it got that way in the first place... Not matter how I alter my printing options, I can't get them OUT of order! If anyone can figure this out, I'd like to know also in case I run into it down the road...


Posted by steve w on August 12, 2001 11:15 AM

Just a thought but perhaps WS2 is sheet1, WS1 is sheet2 and WS3 is sheet3.
Waybe the sheets got mixed up and they dont match the names
steve w