PrintBlackAndWhite Property

 

The PrintBlackAndWhite property returns or sets whether the worksheet printer output is forced to black and white. 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.

 

WksPageSetup.PrintBlackAndWhite

 

Example 2

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

 

WksPageSetup.PrintBlackAndWhite = True

 

Used by: WksPageSetup object