The Data > Data Validation doesn't seem to work when you're using the Input Boxes. I tried setting it and then ran through the data entry macro, but it didn't flag any of the values. If I manually enter the data and it's outside the validation range, it works. So it must have something to do with the macro.
I figured out the automatic printing and here is what I used for future reference.
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
It works so far and only prints out the sheet selected. I just added it after the last InputBox line and once you enter all the data, it automatically prints out a copy of the sheet.
I found some code online that automatically closed the sheet without prompting for a save, but I couldn't get it to work with the printing. I don't have the code, because after I saved it with the new code, it would kick me out after entering data. There was no way for me to get back into the VB editor to remove the code.
I ended up having to go back to my backup. I was thinking about using the "Read Only" option, but if possible, I wanted to get rid of the box all together.
Edited by Spyderturbo007, 18 June 2010 - 01:36 PM.