Ensure that required cells have beeb updated on saving the workboo

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using COUNTA and excluding formulas that gives zero or blank cells 3
Another VB Code Required 7
Update cell value based on name and specific date 1
Saving only updated cells or worksheets 4
Auto-update Fill Series in column that has randomly spaced blank c 3
Counting Nonblank cells based on criteria in another cell 2
Is there a way to add cells based on their shading / fill colour? 2
Temporarily Hiding Text on Repeat Cells in Column-1 3

Top