VB code for printing a worksheet in black and white only

AndrewRossington

Board Regular
Joined
Oct 27, 2005
Messages
114
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.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,118,189
Messages
5,570,760
Members
412,340
Latest member
nikitesh95
Top