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

Match table shading (color) to Visio color/Transparency 1
All Shaded Cells print pure black 1
Excellent code now a question of Feasibility 7
Need help modifying code 0
Shaded cells shift to the right when printing 1
Page numbering with Merged Document and IF statements 1
recognizing conditional formatting with VBA 3
Same text and image color dont match when printed 1

Top