Assign keyboard short cut to subroutine
 

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.

Assign keyboard short cut to subroutine
 

ToolsMacroMacros, select the macro and go to Options.

--
HTH

Bob Phillips

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

"Andy" wrote in message
...
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.