I have a worksheet with ranges filled with background color. Currently I
am using a black and white laser printer. When I print the worksheet
with the printer, the color shaded cells is not clear.

Is there any way to convert all the shaded cell to a 50% grey color
before it prints. I have try adjusting the printer properties to print
in b&w but it print out without any shaded cells. To change all the
shaded cell manually takes a lot of time.

I am asking for a solution is it possible to control through a vba
code? For example, convert all the shaded cells color to 50% grey and
convert back to the normal color after printing. If this cannot be
done, is it possible to make a duplicate copy and change all the shaded
cells with 50% grey and delete the copy after printing.

Thanks for helping.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/