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.





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