Dim sel As Range, ha, va, wt 'mémorise les variables
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
If IsEmpty(ActiveCell) Then Exit Sub
Cancel = True
With Target
Set sel = Target
ha = .HorizontalAlignment
va = .VerticalAlignment
wt = .WrapText
.HorizontalAlignment = xlJustify
.VerticalAlignment = xlJustify
.WrapText = True
End With
Application.OnUndo "Annuler Justifier", "ThisWorkbook.Annuler"
Application.OnRepeat "", ""
End Sub
Sub Annuler()
On Error Resume Next
With sel
.HorizontalAlignment = ha
.VerticalAlignment = va
.WrapText = wt
End With
End Sub