Print in Color Macro

[Guest]

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!

 

[Frank Stone]

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

 

[Myrna Larson]

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