PrintBlackAndWhite Property

PrintBlackAndWhite returns or sets whether the printer output is forced to black and white for a worksheet. It has a Boolean value. If this value is set to 'True', the worksheet will be printed in black and white. If the value is set to 'False', the worksheet will be colored.

Syntax

object.PrintBlackAndWhite

object. PrintBlackAndWhite = BlackAndWhite

Example 1

This example demonstrates how to return whether or not a worksheet is to be printed in monochrome.

Debug.Print WksPageSetup.PrintBlackAndWhite

Example 2

This example demonstrates how to set a worksheet to be printed in monochrome.

WksPageSetup.PrintBlackAndWhite = True

Used by: WksPageSetup object