If, for instance, you have more sheets and you want only sheet1 (our active sheet) to print in black and white, you can use a simple Visual Basic Editor (VBE) procedure to make that happen.