Hi

would setting file / page setup / sheet tab = black & white = true help

AFAIK this only affects the printing not the viewing of the workbook. You
could leave it set all the time or set it using the before print event, if
you wanted to.

Cheers
JulieD

"lawson" wrote in message
...
Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub

i want to use this function to take all the color off the print area, but
when its done printing, i want it to return the color. is there anything
for
after print?