Printing Question?
You might consider creating a named style (Format, Style) that has the
background color you want for normal viewing of the worksheet. Apply that
style to all the cells that you want to change the background of just before
printing.
Then you could use a macro to change the style's background, do the print,
and reset the style's background. For example:
Sub BackgroundChangePrint()
With ActiveWorkbook.Styles("ChgBackground").Interior
.ColorIndex = 16
ActiveSheet.PrintOut
.ColorIndex = 2
End With
End Sub
There is a workbook BeforePrint event that could be used to change the
background before printing automatically, but the problem is that there is
no "after print" event so resetting might be a problem.
--
Jim Rech
Excel MVP
|