I have a question. I have a little VBA script:
Code: Select all
Sub PrintMer()
'Deze functie print de MER-planning in kleur en passend voor 1 pagina
'ActiveSheet.PageSetup.BlackAndWhite = False 'This line does not work, it still prints black and white.
ActiveSheet.PageSetup.Orientation = xlLandscape
ActiveSheet.PrintOut From:=1, To:=1, Copies:=1, ActivePrinter:="Xerox_Secure on PRN-MNG01"
ActiveSheet.PageSetup.Zoom = 80
MsgBox "De opdracht Mer printen is voltooid!"
End Sub
I have heard that VBA can not change the settings from the printer, see picture below:
The question is, can AHK change the settting XEROX Black and White form On to OFF, and should this be done?
Tips and tricks are very welcome!
Thanks in Advance!