+ Reply to Thread
Results 1 to 2 of 2

Can't keep excel printing in B&W

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Can't keep excel printing in B&W

    I have one file that I send out to numerous parties and when they print the file it prints in color even though ALL the printer settings say B&W. Either through the control panel or printer properties. IT says it is the file. I have the print titles marked as black and white, but when I sent the file, the recipient's file did not have that.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,016

    Re: Can't keep excel printing in B&W

    From MS site:https://msdn.microsoft.com/en-us/lib.../ff834921.aspx

    Worksheets("Sheet1").PageSetup.BlackAndWhite = True

    This forum posting: http://windowssecrets.com/forums/sho...g-in-vba-macro

    indicates using :
    It might be worthwhile checking whether setting 'Options.PrintDraft = True' kills the colour output.
    Haven't tested either one, just trying to help.

+ 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: 1
    Last Post: 06-11-2014, 09:23 AM
  2. Replies: 0
    Last Post: 02-27-2014, 01:31 PM
  3. Replies: 0
    Last Post: 09-18-2013, 06:34 AM
  4. Replies: 0
    Last Post: 08-08-2012, 03:12 PM
  5. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  6. Replies: 3
    Last Post: 07-16-2012, 03:24 AM
  7. Disabling Printing ability of a sheet unless printing from a macro
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2012, 04:41 AM
  8. Replies: 4
    Last Post: 06-04-2009, 07:40 PM

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