Sub EreignisEinstellenMP(Blatt)
With ThisWorkbook.VBProject.VBComponents(Blatt).CodeModule
.InsertLines 1, _
"
Private Sub Worksheet_Change(ByVal Adresse As Range)" & Chr(13) & _
"Dim Bereich As Range" & Chr(13) & _
"Set Bereich = Range(""I2:BH72"")" & Chr(13) & _
"If Not Intersect(Adresse, Bereich) Is Nothing Then" & Chr(13) & _
"Adresse.Interior.ColorIndex = 4" & Chr(13) & _
"Adresse.Offset(-1, 0).Interior.ColorIndex = 4" & Chr(13) & _
"End If" & Chr(13) & _
"End Sub
"End With
End Sub
gruss Bernd