hey all,

I created a shared addin project in visual studio 2005, an addin to excel
that creates a button on the excel standard bar and assigns some event to it.
Also, my addin acts an Automation addin i.e., I have some UDFs defined in my
addin.connect class that act as excel formulae. Now when I built the 'Setup
project' of my addin, I got a setup file which I installed on a test machine.
On this test machine, to my surprise, the addin's automation part is not
working but the COM part is working fine i.e., the button is coming up on
the standard bar.

The reason I found out for this is, the Programmable key word is not being
added to the HKCR\CLSID\GUID\ of my addin in the test machine.

How to resolve this problem!? I want excel to recognise the UDFs i defined
in my addin so that it also acts as an automation addin.

Regards.