Disable short cut keys via .NET code

Topic

New Reply

I have used the following code to disable short-cut keys via VB6 Code but the same code does not work in .NET (VSTO) .NET 3.5 SP1

Excel.Application.OnKey “^{s}” ‘ Ctrl+S Save
Excel.Application.OnKey “^{x}” ‘ Ctrl+X Cut
Excel.Application.OnKey “^{c}” ‘ Ctrl+C Copy
Excel.Application.OnKey “^{v}” ‘ Ctrl+V Paste
Excel.Application.OnKey “%{F8}” ‘ Alt+F8 Macros…
Excel.Application.OnKey “%{F11}” ‘ Alt+F11 VBE

What is different? Oh note that OnKey does not appear via IntelliSense.

Thank you

Reply | Quote

Replies

If you are doing this in an add-in, then:

Code:

Me.Application.OnKey("^{s}", "") ' Ctrl+S Save

(note: your code was actually re-enabling the shortcut!)

Reply | Quote

If you are doing this in an add-in, then:

Code:

Me.Application.OnKey("^{s}", "") ' Ctrl+S Save

(note: your code was actually re-enabling the shortcut!)

Thank you Rory. Yea I did figure-out on my own that my sample code was enabling rather than disabling. I just had a blind spot about the need for it being inside () instead of quotes. The code compiled without error and no exceptions were thrown and I am using that as my excuse for being so blind .

Thank you

Reply | Quote