Remove color when printing?

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

 

[George King]

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.

 

[Don Guillett]

try this
Sub black()
With ActiveSheet
..PageSetup.BlackAndWhite = True
..PrintPreview
End With
End Sub