fill color for printing

[hendrikbez]

Hi
On one of my worksheets, I do have columns and rows with fill color and font color, now when I want to print the sheet I only want the font color to be printed, how can I print that the fill color dows not print at all.

[NeedForExcel]

So do you want the Rows having Fill color to not be printed at all? Or you do want to have the rows printed, but without Fill Color?

[hendrikbez]

If I have fill color in my rows/columns and I want to print it, it must print in black and white
If I have font color in my rows/columns it must print in the colors that I have given them.

[NeedForExcel]

Maybe something like this -

Put this on the Workbook Module:

Please Login or Register  to view this content.

[hendrikbez]

Thank you, but still not working, I have make the module, but when I run it does not work, here is my file, the one I need to print is worksheet ALL.
I did put attach my file if it will help

[NeedForExcel]

Hi,

You had put it on a Regular Code Module & not Workbook Module.

See the attached file..

[hendrikbez]

Thank you for the file, but when I open it and enabled macro, and try to print, it still print the fill colors

[NeedForExcel]

Actually the above code is indeed not correct..

See the attached file..

This should work..

[hendrikbez]

Thank you NeedForExel, it is working now

[NeedForExcel]

Glad it helped!

And sorry for the trouble..