Forum Discussion
Shade a cell but not print that color?
Is there a way I can shade a cell, but keep that cell from being shaded when I print the sheet? For example, I want someone to enter data only in the cells I've shaded yellow, but I want the finished...
Thank you Logaraj for the helpful suggestion! This is a fantastic work-around. But unless there is another solution, I presume that I can't BOTH hide the one shaded color but otherwise print my sheet in color.
Hi Joel,
I guess in general that's possible using VBA script if in Workbook_BeforePrint event remove the color from the range and in Worbook_AfterPrint return the color back.
Somethig like that, but this is just an idea.