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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,113,793
Messages
5,544,315
Members
410,602
Latest member
lidovi
Top