Print in Gray Scale
 

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

--
bforster
-----------------------------------------------------------------------
bforster1's Profile: http://www.excelforum.com/member.php...fo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=27559

Print in Gray Scale
 

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

Print in Gray Scale
 

I don't own a color printer, but maybe you could record a macro while you
change:

file|page setup|sheet tab
check Black and White

Is black and white the same as gray scale? Or is this a printer setting?


bforster1 wrote:

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

--

Dave Peterson