bforster

Something like

Sheet1.PageSetup.BlackAndWhite = True

before you print should work.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"bforster1" wrote in message
...

I have a spreadsheet with several cells colored and would like to code a
macro that prints the spreadsheet in grayscale to save color. any
suggestions??


--
bforster1
------------------------------------------------------------------------
bforster1's Profile:
http://www.excelforum.com/member.php...o&userid=11771
View this thread: http://www.excelforum.com/showthread...hreadid=275596