Anstatt Doppelklick, Strg+V
30.09.2020 11:14:18
Mikexcel
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Application.CutCopyMode Then
Target.PasteSpecial xlPasteValues
Cancel = True
'Application.CutCopyMode = False 'beendet Kopiermodus
End If
End Sub