AUTO PRINT potrait & landscape

colleen · Mar 28th, 2002, 06:52 AM

hi , i need to print my documents first page potrait the rest in landscape mode automatically without manually clicking on potrait and first page the landscape for the balance pages. All these douments are on the first sheet .. aid needed colleen

Joe Was · Mar 28th, 2002, 07:12 AM

If you are printing your first page from "Sheet1" and the next page from "Sheet2." Then your "Page Setup" will atuomatically control the print for each page independently. So just set the page options for each sheet. Record a macro and use the print icon to print each page and you are done.

If you need to print multiple pages from the same sheet or you need to set options in your code (this slows down printing alot!), then you need to control the print flow.

Record a macro:

Set the first page, print range select the options, print. Then select the rest of the sheet, but not the part you just printed, set your options like landscape. Then print the selection. Stop the macro recorder. You may need to edit out some of the print code from the recorded macro, as the Excel recorder is particularly dirty when it comes to recording printer code. JSW

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 06:52 AM	#1
colleen Board Regular Join Date: Feb 2002 Posts: 61	hi , i need to print my documents first page potrait the rest in landscape mode automatically without manually clicking on potrait and first page the landscape for the balance pages. All these douments are on the first sheet .. aid needed colleen

Mar 28th, 2002, 07:12 AM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	If you are printing your first page from "Sheet1" and the next page from "Sheet2." Then your "Page Setup" will atuomatically control the print for each page independently. So just set the page options for each sheet. Record a macro and use the print icon to print each page and you are done. If you need to print multiple pages from the same sheet or you need to set options in your code (this slows down printing alot!), then you need to control the print flow. Record a macro: Set the first page, print range select the options, print. Then select the rest of the sheet, but not the part you just printed, set your options like landscape. Then print the selection. Stop the macro recorder. You may need to edit out some of the print code from the recorded macro, as the Excel recorder is particularly dirty when it comes to recording printer code. JSW