Private Sub Worksheet_Activate()
Dim c As Range
Application.ScreenUpdating = False
Sheets("UEP").Copy
With ActiveSheet
.Range("O:W,AM:AU,BK:BS").Delete 'à adapter suivant la feuille
For Each c In .UsedRange
Range(c.Address).Interior.Color = c.Interior.Color
Next
.Parent.Close False
End With
End Sub