What you need is a Workbook_BeforeSave event macro. You can write code into
this macro to do any checks you want and to display any messages you want.
You can also write the code to cancel the Save command if certain checks are
not satisfied.
The cell addresses of the specific cells you want checked have to be
written into the code or you have to setup a range of all those cells and
name it. The following macro does what you want with a range of required
cells named TheCells.
This macro must be placed in the workbook module of your file. To do
this, right-click on the Excel icon to the left of the word File in the menu
at the top of your screen. Select View Code. Paste this macro into that
module.
If you wish, send me direct via email a valid email address and I will
send you a small file that contains this macro properly placed. My email
address is . Remove the "nop" from this address. HTH
Otto
"Tim T" wrote in message
...
I have a worksheet that we are using as a template.

The worksheet has cells we have made in to drop downs.

Can these drop downs be setup as a "Reuired"??

Can certain cells be setup that if they are not complete the sheet won't
save or a error message appears?

Thanks in advance,
TT