dependency protected cells
 

HI!
i have a problem in reference to protecting cells:

my 2 cells A1 and A2
i want that A2 is as long protected as A1 is empty, so that the user has to
fill in A1 first and finally then he can fill out A2.
so i want A2 to be write protected as long as A1 is empty

maybe some of u has a solution that could help me

regards
mario

dependency protected cells
 

Mario,

You can set A1 to unlocked than protect the worksheet with a password.

In the worksheet module have a change event

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "A1" then
ActiveSheet.Unprotect "mypassword"
End If
End Sub

--
sb
"Mario" wrote in message
y.telekom.at...
HI!
i have a problem in reference to protecting cells:

my 2 cells A1 and A2
i want that A2 is as long protected as A1 is empty, so that the user has
to
fill in A1 first and finally then he can fill out A2.
so i want A2 to be write protected as long as A1 is empty

maybe some of u has a solution that could help me

regards
mario