Distributing macros with an addi-in
Please lend a hand to someone who has written a fair number of macros for
Word and is now trying to understand the world of Excel.
The macro in question is simple and runs fine.
I've put it in an ad-in with a custom toolbar with the macro on it, and
written a Workbook_AddinInstall() routine in the ThisWorkBook object that
adds a menu item for the macro; also a Workbook_AddinUninstall() that
deletes it.
These macros also behave as expected when run manually from within the vba
editor.
But here is what happens when I install the add-in on another computer and
then add it using the tools add-ins.
1) The macro is not available using tools macros.
2) The Workbook_AddinInstall() macro does not run and the menu item is not
added
3) The toolbar is available, but the button no longer runs the macro.
If I open the add-in from within Excel, I can then reassign the macro to the
button on the toolbar and then it will run--for as long as the add-in is
open (not just added in, but actually open using File Open).
I'm going to skip the code because the code seems to run fine. The problem
is in how I am going about things. Can someone please tell me what the right
way is? (If there is a decent explanation on the web, a link would suffice
and be much appreciated.)
Thank you very much.
|