Printout with both colour and b/w

		Microsoft Office Forums > Microsoft Excel > Excel
Printout with both colour and b/w

FAQ

Thread Tools

Display Modes

#10

04-21-2017, 11:02 AM

Logit

Windows 10 Printout with both colour and b/w

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

You should be able to remove this portion of the macro :

Code:

With Sheets(1).Range("A1:J72").Interior     'removes background color from sheet cells
        .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With

That should retain the background coloring of the cells.

Let me know.

Tags

printout

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Track Changes Printout	Dana-H	Word	2	09-22-2016 05:45 AM
Insert File Printout w/ PDF fail	jsilvoy	OneNote	0	03-05-2015 06:44 PM
PDF printout distorted	Peter c	OneNote	1	12-07-2014 07:59 PM
MS Project - Resource usage printout	scrinmemphis	Project	1	02-22-2013 02:30 PM
Printout problem with customized bullets	eroock	PowerPoint	2	12-27-2009 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 PM.