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.