dependency protected cells

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

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
 
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
 
Back
Top