Ensure that required cells have beeb updated on saving the workboo
 

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

Ensure that required cells have beeb updated on saving the workboo
 

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.





Margaret wrote:

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

--

Dave Peterson