Re: $$Excel-Macros$$ Protecting certain cells based on conditions

Thank you very much for your help, it worked perfectly!!! On Tue, Jun 14, 2011 at 9:49 PM, ashish koul wrote: > try this > > > Private Sub Worksheet_Change(ByVal Target As Range) > > If Target.Column = 10 And Target.Row >= 8 Then > > 'target.column =3 because column c is no 3 column > > 'you can

Re: $$Excel-Macros$$ Protecting certain cells based on conditions

try this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 10 And Target.Row >= 8 Then 'target.column =3 because column c is no 3 column 'you can change password ashish and choose your own ActiveSheet.Unprotect Password:="ashish" If Not IsEmpty(Target.Value) Then Target

$$Excel-Macros$$ Protecting certain cells based on conditions

I have a worksheet with dollar values in column H, beginning in cell H8 and names in column J, beginning in cell J8. I want to use a formula or vba code to lock a cell in column H based on if there is data entered in a cell in column J. For ex. (if John Smilth is entered in J8, I want to lock H8.