Calling a macro without coding in the worksheet

[soran2484]

I'm not quite sure what it is I'm working with here. I have recently inherited a masterpiece macro from someone I am replacing at work. The macro runs beautifully, but there are complexities that exist because I have no idea how it was originally written. I had an idea to improve on the macro, and have the code now to implement into the macro but there's a rub... I can't figure out how to call my macros with their respective hotkeys like the existing one does already.

The structure of the macro is such that once it has been opened, it populates any instance of excel that's open and won't shut down until all instances of excel are closed. Ctrl+Shift+B will run the macro in any window of excel that you happen to be on. I've learned how to use an application.onkey within the workbook tab of VBA editor, but I have to copy the application.onkey code to each new sheet I open and save in order for the macro to work in the newly opened sheet.

Any idea of where I'd look to find the coding on this master macro that I'm dealing with in order to implement more macro-calling code? I hope this makes sense, as I'm spinning my wheels in air now...

Thanks in advance for the help, and apologize for the length of the explanation.