PageSetup.BlackAndWhite Property

  • Article
Excel Developer Reference

True if elements of the document will be printed in black and white. Read/write Boolean.

Syntax

expression.BlackAndWhite

expression   A variable that represents a PageSetup object.

Remarks

This property applies only to worksheet pages.

Example

This example causes Sheet1 to be printed in black and white.

Visual Basic for Applications 
  Worksheets("Sheet1").PageSetup.BlackAndWhite = True

See Also