Edit

Share via

PageSetup.BlackAndWhite property (Excel)

  • Article

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.

Worksheets("Sheet1").PageSetup.BlackAndWhite = True

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.