Hi
I have a workbook with 5 worksheets, each of the worksheets is a form, in the form there are mandatory fields that I need the users to complete before saving. My issue is this, I can set up the code to prompt the user to complete the missing info but in most instances the user will only be completing one of the 5 forms and therefore I need a way of setting up a code that says if a cell in the worksheet is filled in then all the mandatory cells need completing whereas if all cells are empty then the rule doesn't apply.
Does that make sense?
I have a workbook with 5 worksheets, each of the worksheets is a form, in the form there are mandatory fields that I need the users to complete before saving. My issue is this, I can set up the code to prompt the user to complete the missing info but in most instances the user will only be completing one of the 5 forms and therefore I need a way of setting up a code that says if a cell in the worksheet is filled in then all the mandatory cells need completing whereas if all cells are empty then the rule doesn't apply.
Does that make sense?