The office uses 6 standard Word and Excel VBA macros that I created. Each of these macros is associated with a key shortcut on each computer. When I setup a new computer or reinstall an old one, I take the following steps with the macros.
I create a "junk" macro on the client machine with a name that matches the first of my 6 standard marcos. (We'll call it macro1.) When creating the junk macro, I assign the correct key shortcut to the macro.
After creating the "junk" macro, I replace the contents of the macro with the contents of my macro1.
The result - My macro is functional and associated with the desired key shortcut.
This process is not
efficient. There's got to be a way to import a module into my client's Normal.dotm file (or Personal.xlsb) file and "tell" Word (or Excel) to associate Ctrl + Alt + 1 with macro 1, and Ctrl + Alt + 2 with macro 2...