View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doc Pete Doc Pete is offline
external usenet poster
 
Posts: 1
Default How do I force user to enter their ID# before filling other data?

I am setting up a worksheet to help our staff calculate customer transaction
costs. I want to prevent the staff from entering any data into the worksheet
until they have entered their employee ID in the employee ID cell. In other
words, I want all other data entry cells to remain locked until the person
filling out the worksheet has typed in his or her employee ID.

Thank you for your help.