Printing in both Landscape and Potrait on the same spreadsheet

[jasho]

I have an 8 page spreadsheet and I'm trying to print the first 2 pages in Landscape and the other 6 in Potrait. I would like to eventually send this spreadsheet in this format to people with limited excel knowledge and expect them to print without any issues. Please assist. Thanks.

 

[jasho]

Anyone with an answer to this? Please help!

 

[Domski]

The only way you can really do this is with a Workbook BeforePrint event in VBA to capture when the user prints the workbook and then have a custom print routine to print the required ranges whilst changing the orientation in page setup.

If the user doesn't enable macros though it will obviously not work.

Dom

 

[jasho]

Thanks Dom. Got a macro but thought there was a way to do it without it. Thanks again.

 

[grd]

Couldn't you just split the 2 and 6 pages onto different worksheets and configure the worksheets appropriately?

Most people can cope with printing multiple worksheets.

 

[jasho]

grd,

Thanks for the help. I got a VB code that works perfect.

Sub CommandButton1_Click()
ActiveWorkbook.CustomViews("custom print 1").Show
ActiveWorkbook.PrintOut
ActiveWorkbook.CustomViews("custom print 2").Show
ActiveWorkbook.PrintOut
MsgBox "Priting Complete"
End Sub