I have created a Reimbursement claim form. In this form there are some information has to be filled and based on that some formula is there. I want that if some one fills this then he/she should not leave any required information blank.
Informations are like, Emp Code, Name, Dates etc.
When employee filles this form they never mention Employee code, which is mandatory.
I want to put a validation in that excel file so that they get a prompt massage while saving excel file before filling all required details (all yellow cells in the attached xls file) . They can save only after filling all details.
Can I get some macro for this.