Sub Ultimate_RGPD_Tool()
Dim wbk As Workbook, ws As Worksheet
Application.DisplayAlerts = False
Set wbk = ActiveWorkbook
wbk.Sheets(1).Activate
For Each ws In wbk.Worksheets
If ws.Name = wbk.ActiveSheet.Name Then
ws.Cells.Clear
Else
ws.Delete
End If
Next ws
wbk.ActiveSheet.Name = "Feuil1"
'facultatif
wbk.Sheets("Feuil1").[A1] = "ITEM_1"
With wbk.Sheets("Feuil1").Range("A1:J50")
.Formula = "=ADDRESS(ROW()-1,COLUMN(),4)"
.Value = .Value
With .Item(1)
.Value = "ITEM_1"
.AutoFill .Resize(, 10), 0
.CurrentRegion.Borders.LineStyle = 1
End With
End With
Application.DisplayAlerts = True
End Sub