jamieboss
06-08-2010, 06:30 PM
Currently the only way I can get a sub named 'insert', which is in contained in an add-in, to run, is to record a macro in the actual workbook which calls the procedure as follows.
Application.Run ("addin_20100608.XLa!Insert")
The actual keyboard shortcut activates a macro in my workbook which then calls the macro I actually want to run. How do I do this more directly so that I press a keyboard shortcut and the macro is run from the add in directly.
Many thanks for any help you can provide,
Jamie
Application.Run ("addin_20100608.XLa!Insert")
The actual keyboard shortcut activates a macro in my workbook which then calls the macro I actually want to run. How do I do this more directly so that I press a keyboard shortcut and the macro is run from the add in directly.
Many thanks for any help you can provide,
Jamie