Add this line to Gerry's code.

..BlackAndWhite = True

BTW.......Macros are written using VBA so they are the same thing.


Gord Dibben MS Excel MVP


On Sat, 10 Nov 2007 09:17:01 -0800, Joel wrote:

Thank you very can you please tell me how to print without the colour that is
on the spreadsheet

Joel