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