Clearing background color in printed copies
Disregard that. The colors would print as shades of gray.
What you wouldhave to do is either change all the interior colors to white
or remove them. If the print area is not too large, i.e. one page, you
could just copy the values to another sheet and print that sheet.
"terry w" wrote in message
...
My Sheet has various regions of with various light background colors.
This
is to help staff enter data in the right places! When I print the Sheet,
though, I don't want any background colors to show for the
Range("A7:P30").
Is there a good way to do this? (I still want the background colors to
show
on the screen, just not in the printed copy.)
Terry
|