ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing in Black and White (https://www.excelbanter.com/excel-programming/388251-printing-black-white.html)

Corey

Printing in Black and White
 
I have the:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:=True

But is there a line i can add to set the printer to print only in Black and White?

Corey....



Corey

Printing in Black and White
 
Worked it out:
..BlackandWhite = True

"Corey" wrote in message ...
I have the:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, Collate:=True

But is there a line i can add to set the printer to print only in Black and White?

Corey....





All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com