Christian0258
XLDnaute Accro
Bonjour à tout le forum,
Je souhaiterais verrouiller les cellules, dès que celles-ci ont ces formules...mon code, comment le modifier :
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Me.[E:E], Target) Is Nothing Or Target.Row < 2 Then Exit Sub
Me.Cells(Target.Row, 1).FormulaR1C1 = "=IF(RC[4]="""","""",(TEXT(RC[4],""aaaa"")))"
Me.Cells(Target.Row, 2).FormulaR1C1 = "=IF(RC[3]="""","""",INT((MONTH(RC[3])+5)/6))"
Me.Cells(Target.Row, 3).FormulaR1C1 = "=IF(RC[2]="""","""",INT((MONTH(RC[2])+2)/3))"
Me.Cells(Target.Row, 4).FormulaR1C1 = "=IF(RC[1]="""","""",(TEXT(RC[1],""mmmm"")))"
Me.Cells(Target.Row, 9).FormulaR1C1 = "=IF(RC[-1]="""",0,VLOOKUP(RC[-1],Base,2,0))"
Me.Cells(Target.Row, 13).FormulaR1C1 = "=IF(RC[-8]="""",0,IF(RC[-2]+RC[-1]=0,0,RC[-2]+RC[-1]))"
Me.Cells(Target.Row, 14).FormulaR1C1 = "=IF(RC[-5]=0,0,IF(RC[-1]<>RC[-5],0,VLOOKUP(RC[-6],Base,3,0))*RC[-1])"
Me.Cells(Target.Row, 17).FormulaR1C1 = "=IF(RC[-4]=RC[-8],"""",""x"")"
End Sub
Merci pour le temps que vous voudrez bien vouloir m'accorder.
Bien amicalement,
Christian
Je souhaiterais verrouiller les cellules, dès que celles-ci ont ces formules...mon code, comment le modifier :
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Me.[E:E], Target) Is Nothing Or Target.Row < 2 Then Exit Sub
Me.Cells(Target.Row, 1).FormulaR1C1 = "=IF(RC[4]="""","""",(TEXT(RC[4],""aaaa"")))"
Me.Cells(Target.Row, 2).FormulaR1C1 = "=IF(RC[3]="""","""",INT((MONTH(RC[3])+5)/6))"
Me.Cells(Target.Row, 3).FormulaR1C1 = "=IF(RC[2]="""","""",INT((MONTH(RC[2])+2)/3))"
Me.Cells(Target.Row, 4).FormulaR1C1 = "=IF(RC[1]="""","""",(TEXT(RC[1],""mmmm"")))"
Me.Cells(Target.Row, 9).FormulaR1C1 = "=IF(RC[-1]="""",0,VLOOKUP(RC[-1],Base,2,0))"
Me.Cells(Target.Row, 13).FormulaR1C1 = "=IF(RC[-8]="""",0,IF(RC[-2]+RC[-1]=0,0,RC[-2]+RC[-1]))"
Me.Cells(Target.Row, 14).FormulaR1C1 = "=IF(RC[-5]=0,0,IF(RC[-1]<>RC[-5],0,VLOOKUP(RC[-6],Base,3,0))*RC[-1])"
Me.Cells(Target.Row, 17).FormulaR1C1 = "=IF(RC[-4]=RC[-8],"""",""x"")"
End Sub
Merci pour le temps que vous voudrez bien vouloir m'accorder.
Bien amicalement,
Christian