manual or programmatic way of creating keyboard short-cuts for excel add-ins

is it possible to have a shortcut like ctrl+p to run a certain macro? is there开发者_开发问答 a manual or programmatic way to do this?

It's definitely possible manually. If you're recording the macro you can specify a hotkey before you start recording; otherwise you open the Macro dialog, select the macro from the list, and click the Options button