UserForm has Color but when print must only print in Black

[Darren]

Hi Captains of Excel

When i print my UserForm it prints the color. To save on the expensive color ink the Userform must only print in Black.

My current code to perform the Print

Private Sub CommandButton5_Click()
Me.PrintForm
End Sub

Hope this function can be performed on a userform

Darren

South Africa
:hi:

[lucas]

Darren,
My suggestion is not to print the userform.....it's a bad idea for lots of reasons, some you have already listed.

I have found that it's much better to populate a special sheet set up just to print with the data from the userform...gives you much more flexability. You can create it from a hidden template sheet and delete it when you have printed your report..

[Darren]

Hi Lucas

Can you show me how to populate this special sheet please, i am not sure of the procedure

Darren

[mdmackillop]

Can you set your printer to print black/white? If so, add a second copy of your printer with these settings and print to that.

[lucas]

If you decide to get away from printing the form....
The attachment creates a copy of a hidden template sheet and fills it with the data from your userform, then prints that sheet and then deletes it: see attached.

To see the hidden template sheet go to format-sheet-unhide and look for a sheet named "Blank Sheet" to unhide it. You can format it any way you like and put the data exactly where you want it to print it.

also to actually print..you will have to change the part that says printpreview to printout. I have it set up to just preview now for testing purposes.