Add shortcut key or hot key via vba

Anyone know how to programatically add hotkeys to existing subs 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?
>
>
>

Thanks Ben!
"ben" <[email protected]> wrote in message
news:[email protected]...
> 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?
>>
>>
>>