+ Reply to Thread
Results 1 to 3 of 3

Printing macro- print one sided

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Printing macro- print one sided

    I am currently using the following macro to print certain pages based on activity. The macro launches a print dialogue box. My problem is that I cannot figure out how to control the print settings for all the sheets selected-- I want to set it so that it always prints one sided. However, as it runs now, if you change the setting to one sided, it will only apply to the first sheet printed, and the rest print to however the default settings for the printer are set up (which is usually double sided). Is there anyway to tweak this?

    This is the code I am using currently:
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    05-24-2014
    Posts
    12

    Re: Printing macro- print one sided

    Sub PrintSheets()
    Dim ws As Worksheet, cs As Worksheet
    Set cs = ActiveSheet
    Application.ScreenUpdating = False
    For Each ws In ActiveWorkbook.Worksheets
    ws.Activate
    ws.PrintOut Copies:=1, Collate:=True, _
    IgnorePrintAreas:=False
    Next ws
    cs.Activate
    Application.ScreenUpdating = True
    End Sub

  3. #3
    Registered User
    Join Date
    04-27-2016
    Location
    Brooklyn
    MS-Off Ver
    2010
    Posts
    46

    Re: Printing macro- print one sided

    Thanks-- the problem with this is I need to activate the print dialogue box to choose a printer each time (because this will change) whereas this just activates the default printer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 09-18-2013, 06:34 AM
  2. Printing Double Sided
    By tandi in forum Excel General
    Replies: 3
    Last Post: 08-20-2012, 04:30 PM
  3. recorded the macro:printing double sided
    By sdts in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2010, 08:12 AM
  4. Printing single sided only
    By breimer in forum Excel General
    Replies: 2
    Last Post: 04-08-2009, 04:17 PM
  5. printing double sided
    By stevesunfold in forum Excel General
    Replies: 5
    Last Post: 10-26-2008, 08:31 AM
  6. How to print single sided versus double sided?
    By bobm217 in forum Excel General
    Replies: 1
    Last Post: 12-06-2005, 09:10 PM
  7. How can I print two sided documents in Excel?:print double-sided,
    By Myrna Larson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1