Color in Cells without Showing Up in Print

C

Coby

Does anyone know of a good method for shading Excel cells so that they
appear shaded with color on the screen, but will never be the type of
shading which would print the color?

I want to shade some cells, but never want the color to print
regardless of how the user goes about printing the document.

Thank you,
Coby.
 
J

JP

Haven't tried this out, but could you use the "BeforePrint" Workbook
event to log all of the cells, with color, clear them, then after
printing, restore the colors?
 
C

Coby

Haven't tried this out, but could you use the "BeforePrint" Workbook
event to log all of the cells, with color, clear them, then after
printing, restore the colors?





- Show quoted text -
Click to expand...



Interesting Idea . . I will try that. I don't see why it wouldn't
work. Thanks,JP.

Coby.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't see shading on documents received 5
color selector 2
Count if a cell has color shading 2
Hiding columns with shaded headers 4
print color 4
Printing Question? 2
my cell shade does not appear on screen (except for Print Preview) 1
Get Control Before AND After Printing 1

Top