setting properties for my Color Laserjet Pro with Excel VBA

Vince47 · ‎10-21-2019

Hi,

I just bought some weeks ago an HP Color LaserJet Pro M281fdw printer.

When I have part of my text in colour, the printer defaults and prints in colour.

How can I change the properties of this printer with EXcel VBA so it prints only in B&W saving me the trouble to go and change manually the properties myself before each and every print?

thanks in advance

Vince

Repairatrooper · ‎10-21-2019

If you often want to only print in black you can create a second printer installation and have that driver set to only print in black. Once you have installed, do the following:

On your PC go to Control panel>devices and printers and then right click on the printer that you want to set as monochrome only and select printer properties. On the window that opens, click on device settings and scroll down to install able options and find "device type". by default it shows normally as "auto". use the drop down menu to change it to monochrome and all color features will be removed from the driver.

If you find the information provided useful or solves your problems, help other users find the solution easier by marking my post as an accepted solution. Clicking "yes" on "was this reply helpful" also increases the chances that this solution will help others.
I am a volunteer, offering my knowledge to support fellow users, I do not work for HP nor speak for HP.

Create an account on the HP Community to personalize your profile and ask a question