PageSetup.BlackAndWhite Property (Excel)
True if elements of the document will be printed in black and white. Read/write Boolean.
Syntax
expression .BlackAndWhite
expression A variable that represents a PageSetup object.
Remarks
This property applies only to worksheet pages.
Example
This example causes Sheet1 to be printed in black and white.
Worksheets("Sheet1").PageSetup.BlackAndWhite = True