Hi,
I have created a macro to print 2 selected worksheets in colour - see attached. The problem is, is that it always comes out in black and white and "Leftheader" also appears in the top left of the print which I do not want.
Has anyone got any suggestions how to make it print in colour??
Sub Print_Wallcharts()
'
' Print_Wallcharts Macro
' Macro recorded 26/07/2010 by ste133
'
Dim ws As Worksheet
'
For Each ws In ThisWorkbook.Worksheets
Select Case ws.Name
Case "C3 Wall Chart", "C4 Wall Chart"
With ws.PageSetup
.PaperSize = xlPaperA4
.PrintGridlines = False
.BlackAndWhite = False
End With
ws.PrintOut
End Select
Next ws
MsgBox "All Wallcharts Sent to Printer."
End Sub
Bookmarks