Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim i As Integer
Sheets("Feuil2").Select
ActiveSheet.Unprotect
Application.DisplayStatusBar = True
Application.StatusBar = "Traitement en cours..."
'copier la valeure des deux cellules a droite de celle ou on double clic
Target.Offset(0, 1).Resize(1, 2).Select
Selection.Copy
Application.ScreenUpdating = False
If MsgBox("Ajouter a la commande ?", vbYesNo) = vbYes Then
'coller dans la premiere ligne vide
Sheets("Feuil2").Range("A65536").End(xlUp)(2).Resize(, 2).Value = Target.Offset(0, 1).Resize(, 2).Value
Cancel = True
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Else
' il a cliqué sur Non
End If
Application.ScreenUpdating = True
Application.DisplayStatusBar = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True
End Sub