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.