Excel Macros

[DRowell]

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.

 

[Gord Dibben]

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

 

[DRowell]

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]

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