Print macro that prints certain areas in specific color

Hi

I want to make a vba macro that prints my five visible sheets. That part I have figured out. The next issue is that on my sheets in certain areas, e.g. in sheet1 in the range "C105:S108" I have changed the cell backgroun color into orange to make it clear for the user that these cells must be filled. But when I run my print macro I don't want the printer to print the mentioned area in orange, but change it to standard white. Any nice way to do this and how?

Thanks!

Without seeing your code..

Maybe add line:

Please Login or Register  to view this content.

That line would solve the problem if I wanted the entire sheet in black and white. But I still want the other areas of the sheet in colors.

Does it print all pages in 1 print job or 5 individual print jobs..

The macro prints page 1 to 5 and all five pages have different areas coloured orange. I only want the macro to change the orange areas into white, and then turn it back to orange once printed.

If Individual:

Put This before the .Printout

Please Login or Register  to view this content.

And This after the .Printout Line.

Please Login or Register  to view this content.

As i don't know your code i don't know if you require anything else.

Maybe Post a copy of your Print Code.

Originally Posted by JRidge

If Individual:



As i don't know your code i don't know if you require anything else.

Maybe Post a copy of your Print Code.

Post Your Code please.