Print Preview

[Deborah]

I would like to preview my worksheets that contains
coloured cells as they will print on a BW printer so I
know what my charts etc. will actually look like.

How do I turn off the Print Preview in colour when
printing to a BW printer? i.e. I want to see exactly what
will print depending on what printer I go to (the BW or
the Colour).
Further, I am not asking about the Page Setup option of
checkmarking Black and White as that will print in only
Black and White and not scale my colours and patterns
accordingly to the % they would actually print.

Please advise and thank you.
Deborah

 

[Don Guillett]

Try setting up another printer with it set to black & white and use that
printer.
Or
Sub togglecolor()
ActiveSheet.PageSetup.BlackAndWhite = True = Not _
ActiveSheet.PageSetup.BlackAndWhite = True
End Sub

 

[Guest]

This is a B&W printer only.
Most bizarre, as I have a B&W printer also at home as does
another friend in anther office and we all see the print
preview as it would print.
That is why I don't know what this office could have done
to not show the preview properly.

Please give me another idea if you can think of it.

Thank you

 

[Don Guillett]

You can install a printer that you don't have connected. Try it.
Then use that printer to test (preview only obviously)