leonielroux
New Member
- Joined
- Dec 18, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Good day,
I have a worksheet that have mandatory fields across multiple sheets that I need completed. However, these mandatory fields only become mandatory if they complete Column A, which is like an employee code.
I also have mandatory fields that are dropdowns, but need to be selected (once again, only becomes mandatory if the employee code in Column A is entered).
I have tried the Before Save Event, but then I keep getting the error message that column A is not completed for the empty rows.
How do I prevent the workbook from saving unless the fields with Column A completed, are filled it?
Below is a screenshot of my layout. All the green highlighted columns are mandatory, once the employee code is completed.
I have a worksheet that have mandatory fields across multiple sheets that I need completed. However, these mandatory fields only become mandatory if they complete Column A, which is like an employee code.
I also have mandatory fields that are dropdowns, but need to be selected (once again, only becomes mandatory if the employee code in Column A is entered).
I have tried the Before Save Event, but then I keep getting the error message that column A is not completed for the empty rows.
How do I prevent the workbook from saving unless the fields with Column A completed, are filled it?
Below is a screenshot of my layout. All the green highlighted columns are mandatory, once the employee code is completed.