Printing in Black and White

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

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....
 
Worked it out:
..BlackandWhite = True

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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Macro 4
Print two different areas on a worksheet 4
macro to print a sheet if a cell is a certain value 1
Command Button 6
Printing Macro 1
Print Code Help 5
print scaling 3
Pop Up Message before printing 3

Back
Top