Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Print a Defined Set of Pages each time (XP SP2)

    Hi

    We have a workbook with 17 Landscape pages, but we only ever want to print about 12 pages of these, and I was wondering if it's possible to record a macro to print just some of the pages, so we don't have to keep printing ranges individually.

    The workbook is like this:
    Pages 1 through 7 (print)
    Pages 8 through 9 (don't print)
    Pages 10 and 11 (print)
    Pages 12, 13, and 14 (print, but portrait on a single sheet of paper)
    Pages 15 through 17 (don't print)

    I know this is maybe asking a lot (especially the part about printing 3 pages on a single sheet), but I just thought that maybe it's possible via a macro.

    If it is, can this be done via Tools -> Macro -> Record Macro?

    Thanks heaps in advance for any advice. [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    I guess the easiest way to accomplish this is to use views.

    - Set all print settings (including area, page setup, numbering, etcetera) the way you like.
    - You can also set other view options (zoom percentage, etcetera)
    - Choose View, custom views.
    - click the add button and enter a meaningful name

    Repeat the above for all possible permutations.

    Now to print a certain report, first choose the custom view that contains the settings for it and then just print.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    I tried that, but when I click more than one sheet (so I can use 'Print -> Active Sheets'), Custom Views is greyed out. [img]/forums/images/smilies/sad.gif[/img]

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    When you said "pages" I thought you meant pages of *one* worksheet.

    What you meant to say was how to print a certain set of sheets each time, right?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    Yes. I apologize. I meant to save 17 Sheets. D'oh!

    I've figured out that if I record a macro, I can select the sheets then print them, and the macro remembers which sheets I clicked and printed. So I guess I'm just down to combining 3 sheets into a single printed page. Is that even possible?

    Thanks again, and sorry for any confusion.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    You'll have to copy the areas you want to combine onto one sheet and print that sheet.

    One way to do that if the range to print is not too large is:

    - Select the area
    - copy
    - go to the print sheet
    - Hold the shift key, choose Edit, paste picture link.

    repeat for the other two sheets.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    Fair Enough.

    I was going to paste as a link so that the sheet continued to update, then set the print area and just make that one sheet one of those printed.

    What's the difference b/w pasting as an image or pasting as a link? Is there an advantage.

    P.S. Thanks again for posting and for helping with this. [img]/forums/images/smilies/smile.gif[/img]

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    <hr>is there an advantage<hr>

    Paste as linked picture will also update any formatting changes to the source.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    So, there's no advantage?

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    If you don't need formatting changes in the source cells to be shown in the picture/linked cells: no, there is no advantage.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Print a Defined Set of Pages each time (XP SP2)

    OK. Thanks very much for your help.

    All the best.

    Brian

Posting Permissions

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