Print - Change Cells Fill Colour?

[theghost]

Hello All.

I have set up a spreadsheet to print preview via an assigned command Button.
Many thanks to Warship for helping me with the formula as I didn't know how to do it.
My formula now is;
Code:

Please Login or Register  to view this content.

My problem is this.
The printed range is Q1:AZ43.
But most of the cells fill colour in this print range are Black :-(
So for printing this is a real pain.

Is there a way in VBA to say;
"If any cell in the range Q1:AZ43 is filled with black, change it to white for printing.
&
If any font in the range Q1:AZ43 is white, change this to black for printing.

That's it! That's my question, & headache! :-)
I really don't know if this is possible. But if it is, and someone knows how this could be
achieved, please can someone advise, as I really don't know how to do it.
My VBA skills are quite low,
(Actually very low :-()
As a note, I did try to google for solutions,, I know the following is very very wrong,,
but it might help. I came up with;
Code:

Please Login or Register  to view this content.

Again,, I know it's wrong,, but hey,, I did try to get the essence of it right (I think)

I hope somebody can crack it for me.
It's pretty much the last piece in the puzzle of my spreadsheet.
I hope someone can fathom out a solution.

Many thanks to you all
TheGhost
PS as a note & for cross posting purposes I did try & post this 1st on MrExce.
But something strange happened & it posted it only as a print preview?
I'm waiting for a moderator to tell me why this happened :-(

[theghost]

At the moment it is set to print preview,
But the idea is to offer a Print feature, via the command button on the sheet.

If anybody can help me out here it would be great.
Any cell with black fill, change to white fill in print area.
Any cell with white ink,, change to black ink.
Simple Eh! :-)
So simple,, I can't do it! :-)

Any suggestions are most welcome.
Many Thanks
The Ghost