ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Set the print order of worksheets when printing entire workbook (https://www.excelbanter.com/excel-discussion-misc-queries/212497-set-print-order-worksheets-when-printing-entire-workbook.html)

Jimbo

Set the print order of worksheets when printing entire workbook
 
When I print an entire workbook, the worksheets are not printed in the order
of the tabs in the workbook. Is there a way to set the order that the
worksheets are printed in.

Sean Timmons

Set the print order of worksheets when printing entire workbook
 
Only thing I can think of is there is a macro or some code on the workbook.
Else, it would print left to right. if you got to Tools - macro - macros, is
anything listed? May want to check that. You can also right-click on your tab
and click View Code to see if anything is there.

"jimbo" wrote:

When I print an entire workbook, the worksheets are not printed in the order
of the tabs in the workbook. Is there a way to set the order that the
worksheets are printed in.


Jimbo

Set the print order of worksheets when printing entire workboo
 
I checked for macros in the workbook - none. I also checked for codes on the
sheets there wasn't any. I also selected all the sheets and checked the
print preview, it shows the sheets in the left to right order, but doesn't
print in that order. very weird.

"Sean Timmons" wrote:

Only thing I can think of is there is a macro or some code on the workbook.
Else, it would print left to right. if you got to Tools - macro - macros, is
anything listed? May want to check that. You can also right-click on your tab
and click View Code to see if anything is there.

"jimbo" wrote:

When I print an entire workbook, the worksheets are not printed in the order
of the tabs in the workbook. Is there a way to set the order that the
worksheets are printed in.



All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com