Private Sub Worksheet_Change(ByVal Target As Range)
Dim sUndoList As String
On Error Resume Next
If Not Intersect(Target, Range("A1")) Is Nothing Then
sUndoList = CommandBars.FindControl(ID:=128).List(1)
If Left(sUndoList, 5) = "Paste" Or sUndoList = "Auto Fill" Or sUndoList = "Drag and Drop" Then
Application.EnableEvents = False
Application.Undo
Application.OnUndo "", ""
Application.EnableEvents = True
End If
End If
End Sub