Shortcut Key: Possible to use the Windows Key instead of the CTRL

[mtheriault2000]

Hello

When recording a macro, Excel give the possibility to access the macro using a Shortkey using CTRL + a key. Is it possible to use also the Windows key ( the one just next the left CTRL key on the keyboard

Martin

 

[Colo]

Hi Martin. As far as I know, it's impossible. WINDOWS key works as same as when we press Ctrl + Esc.
Shortcut Key can be set by VBA using Application.OnKey, so the code would be as follows, but it doesn't work.

Application.OnKey "^{ESC}", "MacroName"