Add-Ins
in [General]
|
From: Sean Neill Sean on 27 May 2010 17:16 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?
From: Gord Dibben on 27 May 2010 20:28 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 Neill(a)discussions.microsoft.com> 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?
|
Pages: 1 Prev: Pivot Table ... Stacked Col & Area Graph Next: How to create a crosstab in Excel |