+ Reply to Thread
Results 1 to 2 of 2

Printing preferences not saving when document closes.

  1. #1
    Registered User
    Join Date
    07-31-2017
    Location
    sheffield, england
    MS-Off Ver
    home and business 2013
    Posts
    3

    Unhappy Printing preferences not saving when document closes.

    Heres a fun one for you on a monday morning!

    I've designed a form to be used for incoming orders, which (bizarrely, for me) is working perfectly!
    However, i now want to print the first sheet in the document as double sided A4 (order form to be folded as a letter and given with the other documents), then all the following sheets as one sided A5, x2 on a side of A4 (to be stuck on boxes).
    I've obviously changed all the printer settings in page setup to do this, which worked, so i saved the doc and closed it down. The next time i came to use the form, it printed off using the printer's own default settings (double sided A4). I cannot just go into page setup every time and change the settings to 2 in 1 A5 because there is often 40+ sheets to change individually (I've tried selecting multiple sheets and because it's the printers own settings, not excel settings, it doesn't seem to stick for the other sheets), it'll take far too long. Has anyone encountered this before and found a way for excel to override a network printer settings? Or will i need to produce a macro of some kind to print it off?
    I can change the network printer defaults and user preferences for the one computer that will be using the document, but neither are ideal because of issues wasting paper and still not solving the A5 part.
    Any advice or help will be greatly appreciated. Thanks, Josh

  2. #2
    Registered User
    Join Date
    07-31-2017
    Location
    sheffield, england
    MS-Off Ver
    home and business 2013
    Posts
    3

    Re: Printing preferences not saving when document closes.

    yeah, usually when you extensively google and cant find a decent answer, forums don't help either! For anyone that finds this post, just insert white spaces into the 'page 2' bit of your print area, then it will print ""double sided"" with your intended bits on one side and the white bits on the other side of the page. (i'm too lazy to bother learning how to do macros, although i'm sure you can do that too)

+ 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. Save a public variable after document closes
    By Dalton325 in forum Word Formatting & General
    Replies: 4
    Last Post: 06-17-2016, 07:28 PM
  2. [SOLVED] Printing Preferences not sticking
    By Potatoes and Onions in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2013, 11:21 PM
  3. How do I offer a 'CANCEL' when user closes the document?
    By PosseJohn in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2012, 08:48 AM
  4. Replies: 0
    Last Post: 02-15-2012, 09:07 AM
  5. printing preferences
    By ImboJones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2010, 11:53 AM
  6. How to set printing preferences???
    By manos in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 10:16 AM
  7. How to set printing preferences???
    By manos in forum Excel General
    Replies: 0
    Last Post: 04-12-2005, 08:31 AM

Tags for this Thread

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