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
tab>view code>insert 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
(E-Mail Removed)
"Doc Pete" <Doc (E-Mail Removed)> wrote in message
news:CC2659E3-0A9D-45E6-8291-(E-Mail Removed)...
>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.