BlackAndWhite Property

Microsoft Excel Visual Basic

True if elements of the document will be printed in black and white. Read/write Boolean.

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