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


--
Rmagic
------------------------------------------------------------------------
Rmagic's Profile: http://www.excelforum.com/member.php...o&userid=28595
View this thread: http://www.excelforum.com/showthread...hreadid=486655