Printing order of worksheets

[MMGroup]

I have a workbook with four worksheets, say A, B, C, and D. When I select all worksheets and print them, the printed order is A, D, C, B (which is the original order of the worksheets before I moved them). How do I get them to print in order.

 

[PaddyD]

Really easy way - record a macro of yourself printing the sheets in the order you want, then assign the macro to a button. You can then just click the button to get the right print order.

This is what the macro recorder gave me:

<pre>

Sub printing()
'
' printing Macro
' Macro recorded 28/08/2002 by Paddy
'

'
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Sheets("Sheet3").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub



</pre>
Hope that helps
Paddy

 

[MMGroup]

Thank you for the idea. But, I need to send the file to lots of folks and want the thing to just print correctly. There's got to be a way to fix this!

 

[PaddyD]

To the best of my (limited) knoweldge, you will have to take a macro based approach to this. Pressing the print icon, or selecting print from the menu lists will give you the default print orders. The default is to print them in the order they appear in the workbook. So, 2 options come to mind:

1) Disable the built in print options & give them a print button that prints in the order you want

2) Have a before_print macro that re-orders the sheets into your preferred order so the default print order produces your desired results.


That said, my VBA is limited, so I'll wait to be corrected

Paddy

 

[MMGroup]

You're assuming I know what I'm talking about! I don't know VBA at all.
The problem is that the pages ARE NOT printing in the order of the worksheets. That's all I want them to do.
Dan

 

[PaddyD]

OK - can you describe exactly what's happening at the moment & what you want to happen...

Paddy

 

[MMGroup]

It is in the original post. There are four worksheets, say they are named A, B, C, and D, and they are in that order. When I select all of them and tell Excel to print Active sheets, or if I select Print entire workbook, the order they print in is incorrect (I can't see my original post now, but that's the order.) What I want is for it to print in this order: A, B, C, D
Dan