Create Auto Keys with VBA?? (1 Viewer)

[EternalMyrtle]

Hello,

I am currently using a Macro to assign auto keys. However, since my users are using Runtime, I am finding the program crashes when one attempts to use an auto key when it cannot be used.

I have tried to solve this by using the OnError action to make the macro fail and abort but it is not working.

Is there a way to create auto keys with vba code so that I can insert an error handler in there?

Thank you!

 

[TJPoorman]

In your autokeys macro use "RunCode". The VBA code you use will need to be a public function in a public module

 

[EternalMyrtle]

Thanks for your reply. I should have been more specific: how do I write the code to assign auto keys?

 

[TJPoorman]

I believe that has to be done through the macro not code.

 

[EternalMyrtle]

Ok, got it working thank you!

 

[gemma-the-husky]

I was not able to set autokeys in code, only with macros

I tried to find a way to let users manage some of their own autokey short cuts, but failed.