if you see it in Excel in Tools=Macro=Macros, select it and click the
options button.

You can also look in Excel VBA help for the OnKey command. The macro that
sets this relationship has to run for it to be in effect. You could put
that code in the workbook_Open event.



--
Regards,
Tom Ogilvy

"Mikeymay" wrote in message
...
I have written a macro to distribute within a team and I want a shortcut
key
enabled, e.g. Ctrl+Q, so a macro button doesn't need adding to everyones
toolbar.

How do I do this