Ensure that required cells have beeb updated on saving the workboo

  • Thread starter Thread starter Margaret
  • Start date Start date
M

Margaret

Hi,

I have a spreadsheet that is sent to Project Managers each month for them to
complete some basic information - the majority of the cells can be filled in
using drop down menus however there are 3 cells that need to be updated
manually.

Some of the Project Managers fail consistently to fill in 2 of the 3 cells,
those cells require dates to be entered.

I want to set up the workbook so that it cannot be closed without these
cells being completed. Can anyone help?

Thank you,
Margaret
 
I wouldn't do it this way.

I'd use a nice prominent cell with a formula like:

=if(or(a1="",c9="",d44=""),"Please fill in those cells!","")

Give it a nice big red font so that they can't miss it.
 
Back
Top