hi.
There is no such setting in excel. you designate color
print by selecting to send the output to a color printer
or to a B/W printer. to do that the code looks something
like this:
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
ActivePrinter:= _
"\\OKI-01\OKI-HP4000-01 on Ne01:", Collate:=True
This is from my network. i don't know how yours is set up
so you will have to find that out.
replace "\\OKI-01\OKI-HP4000-01 on Ne01:" with your file
path to the color printer.
Regards
Frank
-----Original Message-----
I'd like a macro to set the print in color to yes or no
but can't seem to
find anything on the subject??

Thanks!
.