The short answer is no.

You can do things to try to coax the user to enter something like showing
messages but ultimately, the user has all the power. No matter what you try
the user can always defeat it if they're so inclined. All they have to do is
close the app or even shut off the computer. How can you stop that?

--
Biff
Microsoft Excel MVP


"KrispyData" wrote in message
...
I read some old posts that state you can create message that tells the
user
an entry is required but it does not enforce it. But, is there a way to
require an entry in a field?