You could create a BeforeSave Event macro that could check for proper entries.

Update this if you find a macro acceptable.
--
Gary's Student
gsnu200706


"Josh" wrote:

I'm working on a spreadsheet that is shared by dozens of users, but the data
input is reviewed by a few of us. To make our trip through the data quicker,
I'm looking for a way to generate an error if they do not fill in certain
fields in the document. Some of the fields are optional, but some should be
mandatory. How do I force them to fill out those fields or get an error
message?

Thanks