mandatory field set up

[divapaxo]

Hi All

wonder if anyone can advise if the following is possible in excel

I have a spreadsheet which has several fields containing data and
what i want to achieve is that when someone comes to close the
spreadsheet , If they have not filled in all the fields required it will
put up a notice to say that field **** must be completed.

your help would be much appreciated

thanks

 

[divapaxo]

Sorry forgot to say in my last message that it is still not working
even though i have put the code in as requested