Kathy
You could use a Workbook_BeforeSave event macro to check for the entries
you want. That way, the user would be unable to save the file if your
criteria is not met. You would include one or more message boxes explaining
to the user what the problem is. HTH Otto

HTH Otto
"Kathy - Lovullo" wrote in message
...
I am looking for some help with making some cells mandatory. I have
created
a small expense report with approx. 20 lines. On each line, if a user
enters
a expense date, I want to make the "Attendee" field mandatory.
I originally thought I could trigger this when printing the form; however,
it is possible the user may just e-mail it.
Besides activating this validation, I am also having problem with the
validation itself.

Any help would be greatly appreciated.