I'm creating several add-ins that will all use the same top-level menu item. The add-ins will be installed as needed. So someone may have just one and someone else may have half a dozen. The right answer, I think, is to have one controlling add-in that handles the menus (and not much [...] Read More...
The COM Add-in (Component Object Model) toolbar button is not on any toolbars by default. You have to add it and then click on it to get to the COM Add-in dialog. First, right click in a blank area around the toolbars and choose Customize Go to Tools on the left and COM Addins [...] Read More...
Hi All,
Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called “User Defined Functions” (UDF). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s...
Hi All,
As many of you know I give away a number of tools for Excel through my site www.jkp-ads.com. Today I have updated the two most popular downloads:
Name Manager (which I created together with Charles Williams, www.decisionmodels.com):
Most important change: the unused names filter now includes...
I was intrigued to see, under the threat from competition commissions around the World, that Microsoft are opening up parts of their code-base and engineering to competitors to make the whole operating system and main applications (Office is mentioned), work better with 3rd party products. I for one...
Hi all,
Let me start this post with a shameless plug: Charles Williams and I developed Name Manager. From my website alone this tool is good for about 60 downloads a day.
Just a couple of weeks ago, all of a sudden Charles and I started receiving complaints about compile errors, which neither of us could...