Bonjour Le forum,
je dois désactiver pas mal de sendKeys, ci après la longue liste qui n'est pas encore exaustive,
Pourriez vous me dire si il existe la possibilité de les désactiver tous avec une phrase en sachant que le clavier et le pavé doivent rester actifs pour saisir des caractères ou des chiffres
Merci
Sub desact_Rac()
With ActiveWorkbook.Application
.OnKey "^c", ""
.OnKey "^v", ""
.OnKey "^x", ""
.OnKey "^{INSERT}", ""
.OnKey "+{INSERT}", ""
.OnKey "+{DEL}", ""
.OnKey "{TAB}", ""
.OnKey "+{ESCAPE}", ""
.OnKey "{ESCAPE}", ""
.OnKey "%{F12}", ""
.OnKey "^%j", "montreX"
.OnKey "^%k", "OuvreVBA"
.OnKey "^y", "SuppScroll"
.OnKey "^u", "Scroll"
.OnKey "{NUMLOCK}",""
.OnKey "%{F11}", ""
.OnKey "+{F10}", ""
.OnKey "^s", ""
.OnKey "^q", ""
.OnKey "^f",""
.OnKey "%{F8}", ""
.OnKey "%{F2}", ""
.OnKey "^{F2}", ""
.OnKey "^{F3}", ""
.OnKey "^{F5}", ""
.OnKey "^{F9}", ""
.OnKey "^{F10}", ""
.OnKey "^{F11}", ""
.OnKey "^{F12}", ""
.OnKey "^h", ""
.OnKey "%{F1}", ""
.OnKey "%{F10}", ""
.OnKey "+%{F2}", ""
.OnKey "^p", ""
.OnKey "^o", ""
.OnKey "^d", ""
.CellDragAndDrop = False
.CommandBars("Ply").Enabled = False
' Application.OnKey "{DELETE}", ""
End With
End Sub