This can be a little problematic. What do you intend to do if the cells are
not filled out. Not save? What if they are half way done and they want to
save it to be completed at a later date? That makes the users very angry. My
favorite is just conditional formats on the required cells that make it
obvious for the users what is required. You can add a button to check that
all cells are completed correctly and have the macro point out any
defficiancies.

HTH

"Mike S" wrote:

I would like to set up a worksheet with cells that must be filled out. I was
thinking a macro in the BeforeSave event, that would give an error if those
cells do not have a value. I understand this would be limited as it would not
work for somone with macro security set to High or who disables macros.
How would I write this code, or any more reliable ideas?