Private Sub Worksheet_Change(ByVal Target As Range)
With Range("A6:A" & Application.Match("*Total*", [A:A], 0) - 1)
If Intersect(Target, .Cells) Is Nothing Or .Row < 6 Then Exit Sub
Application.ScreenUpdating = False
Application.EnableEvents = False
On Error Resume Next
Columns.Hidden = False 'RAZ
.Replace "Nouvel employé", "#N/A", xlWhole
.SpecialCells(xlCellTypeBlanks) = "#N/A"
Rows(5).SpecialCells(xlCellTypeFormulas, 16).EntireColumn.Hidden = True
.Replace "#N/A", "Nouvel employé"
Application.EnableEvents = True
End With
End Sub