Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2005
    Location
    Linthicum, Maryland, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print settings for workbook (2K (9.0. 4402 SR-1))

    I normally work in Word and I'm not too familiar with Excel. I want to print a Workbook to a PaperPort printer (a virtual printer like PDF) so I can create pictures of the pages. This works out better than actually scanning. However, the worksheets each have their print quality setting set to 600 or 1200 dpi and I want it set for 250 or 300 to keep my tifs smaller.

    I found out I have to set it separately for each worksheet. Is there any way to do it for all worksheets at the same time? Have to do the same thing if I PDF the file - Acrobat won't PDF a file with varied print settings; they all have to be the same.

    Thanks for any help you can give me.

  2. #2
    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: Print settings for workbook (2K (9.0. 4402 SR-1))

    You can do it manually by selecting all the sheets (select the first, then while holding shift select the last)
    Then select file - page setup... page(tab) selct the desired print quality.

    If you want to do it with a macro you can use something like this (add it to a module in VB)
    <pre>Option Explicit
    Sub SetPrintQuality()
    Dim sht
    For Each sht In Sheets
    sht.PageSetup.PrintQuality = 250
    Next
    End Sub</pre>


    Note that not all printqualities are available for all printers. Make sure that the number you pick is available or you will get an error.

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print settings for workbook (2K (9.0. 4402 SR-1))

    Hi Potternm,

    Just to add to Steve's reply.

    If you plan to use the macro that he supplied, I would suggest that you place the macro into Excels personal macro workbook! Doing this will ensuere that the macro is always available when you need to run it, irrispective of which workbook you are working in at the time.
    Follow these steps to place it into the personal macro workbook...
    1. Open a blank new workbook.
    2. Start a new macro recording by going to TOOLS | MACRO | RECORD NEW MACRO
    3. Type Test as the macro name in the dialog box. (We will delete it later!)
    4. From the store macro in dropdown box, select Personal macro workbook.
    5. Choose OK.
    6. The PC is now recording. If a toolbar has appeared, click the stop button (blue square), else go TOOLS | MACRO | STOP RECORDING.
    7. Now choose TOOLS | MACRO | VISUAL BASIC EDITOR
    8. You should see the Project Explorer window on the top left of your screen. (If not press Ctrl + R)
    9. Double click on VBA Project (Personal.xls)
    10. Double click on Modules and then double click Module 1.
    11. Paste Steves code into the sheet on the right side. You may see the test macro here too. You can delete it is you want to!
    12. Close the VBA editor and close Excel too. (When Excel closes you will see a prompt saying that changes were made to the Personal macro workbook...do you want to save it. Choose YES.)

    The macro will now be available to all workbooks, and you can run it anytime you need. Just go TOOLS | MACRO | MACRO'S, and choose it from the macro list box.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  4. #4
    Star Lounger
    Join Date
    Jan 2005
    Location
    Linthicum, Maryland, USA
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print settings for workbook (2K (9.0. 4402 SR-1))

    Thanks to both of you -- selecting all tabs and changing the print settings is so easy I may not need the macro. However, if I decide to try it out (haven't had a chance to do that), at least now I know how to go about it and where to save it. Thanks, will save me tons of time.

Posting Permissions

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