I am using a black and white laser printer, and want to make the three values in the histogram have more contrast. The code I am using is as follows:
ActiveChart.PageSetup.BlackandWhite = True
.
.
.
ActiveChart.FullSeriesCollection(1).Select
With Selecton.FormatFill
.Patterned...
I know that:
.PageSetup
.BlackAndWhite = True
Will print in black and white but if I have a box with a gray background it will only print it as white.
Is there a grayscale option so when I print a box with a gray fill it comes out as gray not white?
Is there a way to force a sheet to print out in black and white without changing the sheet itself to black and white. I was thinking of something that physically tells the printer to print in black and white vs. color.
My thing is that I have a lease copier that charges me a ton for color...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.