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!

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

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