This is a third (and hopefully final) question to two previous questions. Is it possible to have the columns highlighted in Blue Hidden? Also, I have added two additional (reference only) columns in yellow. This is only to allow the user to see the actual value of the Vendor and Category they entered to show if they made a mistake or not. Would it also be possible to un-hide all of the blue columns when the form is Submitted (Emailed)? Would this code go in the Mail_Mode...? I have provided a screen shot pic and attached a matching workbook.
All of the validations work perfect! The form works very quick and is virtually seamless in its email transition. Also, I added code that would close the workbook altogether once they have hit the submit button and emailed it on. I am contemplating other "protection" measures on the actual working form (ie: uneditable header fields, column widths, etc.)
Here is the link to the previous question: