Remove color when printing?

  • Thread starter Thread starter Randy Starr
  • Start date Start date
R

Randy Starr

I have spreadsheets that have multiple cells with color
backgrounds. The cells vary on each sheet. Is there
anyway to print the spreadsheets with the color not
showing up?

Any help would be greatly appreciated.
 
Some printers will let you set them to B/W only.
Go into the Printer's properties.
On mine (a QMS) I go into 'Printing Preferences', then to
a 'Quality' tab.

You may be able to get to this in Excel's Page Setup by
going to 'Options'. This is also setting the printer
defaults, so it will stay B/W for every application until
you go back into the printer's properties and reset it.
 
try this
Sub black()
With ActiveSheet
..PageSetup.BlackAndWhite = True
..PrintPreview
End With
End Sub
 
Back
Top