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.

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?


On Oct 4, 3:36 pm, Coby <coby.giff...@selectbuild.com> wrote:
> 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.

On Oct 4, 2:22 pm, JP <jp...@sterlingtesting.com> wrote:
> 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?
>
> On Oct 4, 3:36 pm, Coby <coby.giff...@selectbuild.com> wrote:
>
>
>
> > 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.- Hide quoted text -
>
> - Show quoted text -



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

Coby.