Is it possible to create a macro in Excel that will allow you to print in
black and white or color. For example, I want to create two macro buttons in
my worksheet that allows me to choose if I want printing in color, or black
and white, depening on which macro button I select.

Use the macro to record while you do each setup.

Assign these macros to buttons craeted from the Forms Toolbar.


Gord Dibben MS Excel MVP

On Fri, 29 May 2009 14:19:01 -0700, DRowell
wrote:

Is it possible to create a macro in Excel that will allow you to print in
black and white or color. For example, I want to create two macro buttons in
my worksheet that allows me to choose if I want printing in color, or black
and white, depening on which macro button I select.

I had done that, but when I go to print, whichever macro I recorded last is
how the documents always seem to print. For example, I recorded a macro and
changed the printing so it would be in black and white first, then in color
with the second macro. I then assigned the macros to buttons, but when I
click on the "black and white" version, it comes out in color because that is
how the last page printed came out.

Is there somewhere different, other than print properties, that I need to
change from color to black and white?

Thank you.

Don

"Gord Dibben" wrote:

Use the macro to record while you do each setup.

Assign these macros to buttons craeted from the Forms Toolbar.


Gord Dibben MS Excel MVP

On Fri, 29 May 2009 14:19:01 -0700, DRowell
wrote:

Is it possible to create a macro in Excel that will allow you to print in
black and white or color. For example, I want to create two macro buttons in
my worksheet that allows me to choose if I want printing in color, or black
and white, depening on which macro button I select.

I have tested my theory on a worksheet in Excel 2003 and cannot replicate
the problem.

Two macros, two buttons. Output is changed depending upon which macro is
run.

Your recorded code should look like this.

With ActiveSheet.PageSetup
bunch of other setup linesf
.BlackAndWhite = True or False
more linesf
End With


Gord

On Fri, 29 May 2009 15:36:01 -0700, DRowell
wrote:

I had done that, but when I go to print, whichever macro I recorded last is
how the documents always seem to print. For example, I recorded a macro and
changed the printing so it would be in black and white first, then in color
with the second macro. I then assigned the macros to buttons, but when I
click on the "black and white" version, it comes out in color because that is
how the last page printed came out.

Is there somewhere different, other than print properties, that I need to
change from color to black and white?

Thank you.

Don

"Gord Dibben" wrote:

Use the macro to record while you do each setup.

Assign these macros to buttons craeted from the Forms Toolbar.


Gord Dibben MS Excel MVP

On Fri, 29 May 2009 14:19:01 -0700, DRowell
wrote:

Is it possible to create a macro in Excel that will allow you to print in
black and white or color. For example, I want to create two macro buttons in
my worksheet that allows me to choose if I want printing in color, or black
and white, depening on which macro button I select.