View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default 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