Sub Test()
Dim LOt As ListObject, TSt As TableStyleElement, Rng As Range, IntTSt As Interior, IntRng As Interior
Set LOt = Feuil4.ListObjects(1)
Set TSt = LOt.TableStyle.TableStyleElements(xlHeaderRow)
Set Rng = LOt.Range
Set IntTSt = TSt.Interior
Set IntRng = Rng(1, 1).Interior
If MsgBox("Couleur de fond de l'entête." _
& vbLf & "Définie par le style de tableau """ & TSt.Parent.Parent.Name & """ :" _
& vbLf & "— Pattern=" & IntTSt.Pattern & ", ColorIndex=" & IntTSt.ColorIndex & ", Color=" & IntTSt.Color _
& vbLf & "Définie par le format surajouté :" _
& vbLf & "— Pattern=" & IntTSt.Pattern & ", ColorIndex=" & IntRng.ColorIndex & ", Color=" & IntTSt.Color _
& vbLf & "Voulez vous supprimer le formatage surajouté ?", vbYesNo) = vbNo Then Exit Sub
With Rng.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub