Hello All
I have a workbook with one worksheet with various cell to be filled in by various members of staff, then saved and e-mailed to myself.
What I would like to if cells in the range A1:A10. are not filled in when they try to save the file:
1) Prompt them to fill in this range with a message
2) Prevent them from saving the file until these cells are populated
Does anyone know how to do this in VBA?
Best Wishes
Thomas
I have a workbook with one worksheet with various cell to be filled in by various members of staff, then saved and e-mailed to myself.
What I would like to if cells in the range A1:A10. are not filled in when they try to save the file:
1) Prompt them to fill in this range with a message
2) Prevent them from saving the file until these cells are populated
Does anyone know how to do this in VBA?
Best Wishes
Thomas
