Sub Macro1()
ActiveSheet.Unprotect Password:="motdepasse"
Rows(ActiveCell.Row).Insert Shift:=xlDown
Cells(ActiveCell.Row - 1, 13).AutoFill Destination:=Range(Cells(ActiveCell.Row - 1, 13), Cells(ActiveCell.Row, 13)), Type:=xlFillDefault
Cells(ActiveCell.Row, 1).Select
ActiveSheet.Protect Password:="motdepasse"
End Sub