Print in Gray Scale

  • Thread starter Thread starter bforster1
  • Start date Start date
B

bforster1

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

Something like

Sheet1.PageSetup.BlackAndWhite = True

before you print should work.
 
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?
 
You must log in or register to reply here.

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

Excel VBA - Problem with Closing Print Preview 0
Copy Cells Fill Color 6
Printing gray 6
bmp from scratch 2
Copying a Picture From Cell Comment 0
Print Preview shows in Grayscale - Excel 2003 4
autoshapes - identification and property change 1
Exclude gray figures from sum 6

Back
Top