Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Warrenton, Virginia, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    automatic printing of mutiple sheets (office 97)

    How can I print multiple sheets of a workbook instead of printing each individually? Example - I have a book with 10 sheets. I need to print 3 of them each week and each month I need to print 6 of them. I don't need the front or back sheet printed. Is there a way to print all (that I need) at one time with one print command?
    Thanks

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

    Re: automatic printing of mutiple sheets (office 97)

    Select the sheet(s) while holding the control key (or click the first, hold the shift key and click the last. The issue the print command. One drawbakc: pagenumbering will add up from one sheet to the other.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: automatic printing of mutiple sheets (office 97)

    Do you have the Report Manager ? I have used it in Excel97. I had to add it in from the disk, as I recall, and then accessed it under View / Report Manager. Whether it's in the later ones or not, I don't know. It enables you to select sheets, scenarios and other complex settings under a Report name and then run that. I used it alot for Financial Statements and schedules. HTH

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: automatic printing of mutiple sheets (office 97)

    Tony,
    In the past I have used macros to print. Create one macro that will print the three sheets and a different macro to print the 6 sheets.
    Hope this helps.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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