Just create a workbook (I'm assuming in Excel) with VBA code, and "save as" file type "Microsoft Excel AddIn". Then you can make it available (i.e., load it every time Excel starts) using the Tools - AddIns... command. Anything else (such as custom toolbars, menus, etc) is specific to your own goals.
this thread has been closed for a while, but i'm trying to create an add-in which is to be available to all my colleagues in the global template
the add-in will contain code that is currently in the modules of an existing spreadsheet.
the way i want it to work is that the code will run when a button on the toolbar is pressed and the code will do its magic on the spreadsheet that is currently open. perhaps this is the point of an add-in, i don't know, this is a learning curve for me.
doesn't appear to do anything to a worksheet in the open workbook. is it doing something to a hidden worksheet in the .xla file, perhaps? how would i refer to worksheet in the open workbook? what if there are several workbooks open?
...now how do i remove an add-in programmatically? if this is possible, how do i remove the very add-in containing the code to remove the add-in?
what i am trying to do is this: let the user run the code behind the add-in somehow. i don't know the standard way to do this, so i plan to tell people to install the add-in; the code will run on the install event, finish running, then uninstall itself.
i could put a button on the toolbar to run the code, but the button would be redundant if the add-in weren't installed.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.