To add a shortcut key to a macro, you can hit ALT+F8 to bring up the macro dialog box and then select your macro and click on Options and it should be straightfwd from there. Don't forget to save your macro file.