Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: AUTO PRINT potrait & landscape

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •