PrintBlackAndWhite Property

The PrintBlackAndWhite property returns or sets if the printer output is forced to black and white for a worksheet. Returns a Boolean.

Syntax

object.PrintBlackAndWhite

object.PrintBlackAndWhite = BlackAndWhite

 

Parameter	Type	Description
BlackAndWhite	Boolean	required, true to print as black and white

 

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