Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Distributing a UDF | Excel Programming | |||
Please let me know from where I can download Analysis Toolpak Addi | Setting up and Configuration of Excel | |||
distributing add-ins | Excel Programming | |||
Distributing Macros | Excel Programming | |||
preserving type library references when distributing macros | Excel Programming |