Color Printer Macro

[RJ1969]

Hi
An issue came about when I was trying to change the settings on the printer from this code:

Please Login or Register  to view this content.

It changes the Sheet1 but I am actually targeting Sheet2.


My button is in Sheet1 and I need DialogPrint for Sheet2 and not for sheet1.

This is the entire macro vba code.

Please Login or Register  to view this content.

Thanks.

[RJ1969]

I tried to do this code but error exist.

Please Login or Register  to view this content.

[RJ1969]

Hi guys,
I found this code somewhere and it does exactly what i was trying to do.
But the problem my Sheet2 does not print color although it as ask if I want to print in color. Help please.

Please Login or Register  to view this content.

[RJ1969]

Guys,
I think I got it. I kinda fix this code:
After the msg box "Do you want to print in color"? ALL I JUST NEED IS TO ADD A MSG BOX "Do you want to print?" "yes" and "no" or "Cancel"

Please Login or Register  to view this content.

[RJ1969]

The reason I want to cancel the print because I want this thing to show after I "cancel" the printing. After I click "do you want to print in color" and I click " yes" then it printed and the below codes which I want to show then it printed twice. I want to add a "cancel' on the above code so I can use the below code. Please. Thank you

Please Login or Register  to view this content.