Setting HotKey Programmatically

S

Sprinks

After creating several dozen macros for our workgroup, the issue has come up
that, as we all work differently, using some macros more than others, we have
differently preferences for which hotkeys are assigned to them.

While each user is free to customize the hotkey settings himself, I'd like
to spare them the trouble after each update. Moreover, on the custom menu
that loads with the macro sheet, the hotkey assignments are listed next to
the menu choices to assist learning.

I'd like to set up a table on the sheet where each user can quickly
customize his choices rather than dealing with the Macro, Options, set key
function. I would read the table on loading, and set the hotkey and menu
choices programmatically.

Does anyone know how to do this?
Thanks.

Sprinks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top