Results 1 to 13 of 13
  1. #1
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine separated print selections on one page (20

    Hi

    I have an Excel spreadsheet on which I've selected the top and bottom thirds as print areas. The middle third is an input area that I don't want to print.
    I've been unable to combine the two areas to print as one page. Excel insists the top selection print as page one and the bottom as page two. The print areas are not large and both should easily fit on one page.
    Is there a way to combine the selections to print as one page by default?

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combine separated print selections on one page (20

    Not on the existing worksheet, unless you shuffle the ranges around so that you have one contiguous print area.
    You could create a new sheet, and paste link the two areas onto it, next to or below each other. Use this sheet for printing.

  3. #3
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    OK Hans

    Thanks for the quick reply.

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  4. #4
    2 Star Lounger
    Join Date
    Jul 2004
    Location
    Hampton, New Hampshire, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    Just a thought but you could also consider selecting the entire area as your 'Print Area' and then hide the rows that you do not want printed just before you go to print it. When you go to print Excel will print everything except what you have hidden.
    <font face="Comic Sans MS">MickeyMouse</font face=comic>
    How best to describe the Lounge-
    "Coming together is a beginning, staying together is progress, working together is success"

  5. #5
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    Hi MM

    Yep, that's what I ended up doing.
    Mary helped me with some VBA code to automate the printing at the click on a button.
    Works great.
    Now I've decided to incorporate a "Save As" on print, selecting an existing text field as the file name. (Expect a few more questions in this forum before I'm done). <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Combine separated print selections on one page

    You may want to take a look at the View > Custom View menu. I often find people writing code to repeat this menu function.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  7. #7
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    Thanks for the suggestion Catherine. I'll take a look at that possibility.

    My end result has to be ...ahhhh...goofus proof. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    The users will have to open the spreadsheet, enter supplied data into very obvious fields, press a very obvious button, and be done.
    Such is life. <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  8. #8
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    I'm back at this little project and have another little problem.

    My vba print routine works OK ("hides" specific rows from printing) as long as the worksheet is not protected.
    Some of the cells within the hidden area need to be protected.

    Is there some way to allow the specific rows to be hidden for printing without unprotecting them?

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    The macro can unprotect the sheet do what it needs to do and then protect it again:

    <code>
    Worksheets("MySheet").Unprotect "MyPassword"
    'Print
    Worksheets("MySheet").Protect "MyPassword"
    </code>
    Legare Coleman

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combine separated print selections on one page

    If you are using Excel 2002 (XP) or later, you can specify that the user can format rows when protecting the worksheet. This allows you to hide rows.
    If you're using Excel 2000 or earlier, or if you don't want the ability to format rows, you could let your macro

    1) Unprotect the worksheet
    2) Hide some rows.
    3) Print the worksheet.
    4) Unhide the rows.
    5) Protect the worksheet again.

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Combine separated print selections on one page

    You could have your routine:
    unprotect the sheet
    hide the rows
    print the sheet
    unhide the rows
    then reprotect the sheet.

    Steve

  12. #12
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    Hi Legare and Hans

    Thanks for the quick replies.

    I figured that would be the answer but was hoping to not have to protect the vba code.
    Then again, I guess it only makes sense to protect both the worksheets and the vba.

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

  13. #13
    5 Star Lounger
    Join Date
    May 2002
    Location
    43.8N 81.0W, Ontario
    Posts
    815
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine separated print selections on one page

    Hi Steve

    Not quite quick enough, eh. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Thanks anyway. I've ended up doing as you and the others suggested.

    I can now print preselected areas of the worksheet and save as a filename taken from a worksheet cell to a predetermined directory by clicking on one button on the worksheet.
    Probably not a professional solution, but it works for me (so far).

    Have a Great day!!!
    Ken
    <IMG SRC=http://www.wopr.com/w3tuserpics/KenK_sig.gif>

Posting Permissions

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