VB code for printing a worksheet in black and white only

[AndrewRossington]

Does what it says on the tin!

I have several different colour worksheets which I'd like to keep colourful onscreen, but I'm not wasting ink on them if I print them.

I need help making some VB code that I can combine with some previous code I kindly received from someone here, and use it so that when a button is pressed, the current sheet is printed in black and white.

Maybe something where:

It turns the entire page to black text, white background.

Prints the page.

Reverses the colour change back to the colour it was originally.

I know the logic.. I just don't know how to use VB!

Any help would be super.

 

[Andrew Poulsom]

Don't you just need?

ActiveSheet.PageSetup.BlackAndWhite = True

 

[AndrewRossington]

That's great, thanks amigo.