If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add-Ins
I have created an Add-In, by openning the VBA, inserting code into a general
module and then saving the workbook as a Excel Add-In. I then added the file to my Add-Ins through Add-Ins manager. The formula works yeah!, but doesn't show in the list of available formulas as I type. I would like to roll this out to other users in my office. Thoughts? |
#2
|
|||
|
|||
Add-Ins
What code did you insert into your Module in the Add-in you created and why
should it show up in list of available formulas? Only User Defined Fuctions will show up in the User Defined category of Functions. Gord Dibben MS Excel MVP On Thu, 27 May 2010 14:16:46 -0700, Sean Neill Sean wrote: I have created an Add-In, by openning the VBA, inserting code into a general module and then saving the workbook as a Excel Add-In. I then added the file to my Add-Ins through Add-Ins manager. The formula works yeah!, but doesn't show in the list of available formulas as I type. I would like to roll this out to other users in my office. Thoughts? |
Thread Tools | |
Display Modes | |
|
|