Hello
I have a form that inputs data into a sheet then you click a button to print 2 copies (one on a green sheet and one on a white sheet)
BUT Is it poss before printing a message box to appear and ask the user to insert the "white copy" then after printing a second message box to appear asking the user to insert "Green copy"
Is it also poss for a macro to control a printer and make it form feed the sheets the reason is when printing the white and green copy you have to form feed them and when you print from any other program or a different excel sheet it prints from the paper tray. I know that this is a long shot!!!!
Thanks
Bookmarks