Add shortcut key or hot key via vba
 

Anyone know how to programatically add hotkeys to existing subs via vba?

Add shortcut key or hot key via vba
 

you could use the OnKey method eg.


application.OnKey "^{a}", "yoursub"

will assign the key shortcut crtl+a to the sub "yoursub"

"Job" wrote:

Anyone know how to programatically add hotkeys to existing subs via vba?

Add shortcut key or hot key via vba
 

Thanks Ben!
"ben" wrote in message
...
you could use the OnKey method eg.


application.OnKey "^{a}", "yoursub"

will assign the key shortcut crtl+a to the sub "yoursub"

"Job" wrote:

Anyone know how to programatically add hotkeys to existing subs via vba?