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.
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
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
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
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.