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