Assigning a Shortcut Key to a Sub Procedure

[FARAZ QURESHI]

I am trying to gather up some useful macros, UDFs and sub procedures in a
module and save the file as an Excel 2003 AddIn, like for instance displaying
few Forms.

Now, that I have the collection made, I want to assign a shortcut key to one
of the Form, SubProcedure or Module how to do so? Even upon installing such
an AddIn, now when I press Alt+F8 such macros are not even listed.

Thanx in advance,

 

[Shane Devenshire]

Hi,

Press Alt+F8 and type the name of the macro in the Macro Name box. If you
spell it correctly the Options button, and others, will become available.
Click Options and assign the shortcut key.

Remember you can assign any of the 26 lower or upper case letters, but since
Excel uses all but 4 or 5 lower case letters it is generally safer to use the
shifted letters. In 2007 even some of the 4 or 5 are used.