I have created a custom add-in with custom functions and am trying to make it user friendly for other users. By running the following macro I can add functions to different categories, but I was wondering if there was a way to do this automatically so that anyone that adds this add-in will have the functions show up in the proper category without having to manually run this macro.
Please Login or Register to view this content.
Last edited by djt76010; 11-25-2008 at 06:48 PM.
You can run registration macros in the Workbook_AddinInstall() event.
Entia non sunt multiplicanda sine necessitate
I tried adding the following code to the same Module that my custom functions are in, but it didn't work when I added the Add-In. What am I doing wrong?
Please Login or Register to view this content.
Add a Stop statement, save the add-in, uninstall, and then reinstall. Does it break?
It belongs in the ThisWorkBook module for the add-in workbook, not in a standard code module.
--JP
Originally Posted by djt76010
I tried adding the following code to the same Module that my custom functions are in, but it didn't work when I added the Add-In. What am I doing wrong?
Please Login or Register to view this content.
That too, thanks JP. Sorry for not reading your post more closely, djt.It belongs in the ThisWorkBook module for the add-in workbook, not in a standard code module.
You guys were a big help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks