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.

One way is to not allow ANY entries until entered. Right click sheet
tabview codeinsert this

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Range("a1") = "" Then
MsgBox "Enter ID in A1"
Target = ""
End If
Application.EnableEvents = True
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Doc Pete" <Doc wrote in message
...
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.