Hi, Frank:

It IS possible to print in B&W using a color printer (but not the converse, of
course). The way you do that is to set a property of the PageSetup object for
the specific worksheet, something like this:

ActiveSheet.PageSetup.BlackAndWhite = True



On Thu, 21 Oct 2004 10:23:02 -0700, "Frank Stone"
wrote:

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!
.