Option Explicit
Private Sub Worksheet_Activate()
Worksheets(ActiveSheet.Name).Unprotect
Range("J5").Locked = False ' Déverouille la liste déroulante en J5
With Columns(1)
.Clear
[TabPL].Columns(1).Copy
.Cells(1).PasteSpecial xlPasteValues ' Coller les valeurs uniquement
.Sort .Cells, xlAscending, Header:=xlNo 'tri
.NumberFormat = ";;;"
End With
Worksheets(ActiveSheet.Name).Protect
End Sub