Microsoft Office Forums - View Single Post - Printout with both colour and b/w

Thread: Printout with both colour and b/w

View Single Post

Old

04-21-2017, 11:02 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

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.

Reply With Quote