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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,119,060
Messages
5,575,862
Members
412,688
Latest member
KYLE1788
Top