Assign keyboard short cut to subroutine

[Andy]

you can assign a keyboard short cut to a maco as you record it. Is it
possible to assign similar to a subroutine that you have contructed manually.
If not and it can only be done with macros, how do you write a macro manually
to include the subroutrine. In Access this is easy but it does not seem so
obvious in Excel.

Wher this is leading to is that I want to create a soubroutine and then save
the workbook as an Add-In. I then want other users to be able to access the
subroutine via the add-in using a keyboard short cut.

Thanks,
Andy.

 

[Bob Phillips]

Tools>Macro>Macros, select the macro and go to Options.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)