Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Question?
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing question | Excel Discussion (Misc queries) | |||
printing question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Worksheet Functions | |||
Printing Question | Excel Discussion (Misc queries) |