How do I create a mandatory field in Excel
 

I have a log using excel. I want the data entry staff to use their initials
on the log when entering data. I want that initial field to be mandatory.
How can I set it up to be mandatory?

How do I create a mandatory field in Excel
 

Why not get them to give you initials on start up, in an InputBox maybe.
Then you can add it yourself each time and save the user the trouble of
entering the same thing each line.

Or the current logged-on user, you could generate something yourself, either
with :
Environ("UserName")
GetUserName API call

NickHK

"RSP" wrote in message
...
I have a log using excel. I want the data entry staff to use their
initials
on the log when entering data. I want that initial field to be mandatory.
How can I set it up to be mandatory?