com add-in works on development machine fails in prod

[julian_cropley]

I am developing an Excel com add-in in dot net.
Currently the program works on the development machines, but on a
production machine the add-in is disabled. (The reigistry setting
loadbehavior is being set to 2 by excel.)
Surely the OnConnection event in the IDTExtensibility2 interface must
be causing some problems. However there is a try catch block there
which displays a message box if any error is caught. No messagebox is
displayed. So it doesn't seem to be getting inside the code in the
onConnection event.
Is there any way to see why an addin is being disabled?

TIA
Julian Cropley

 

[Lars]

Hi,

I would suspect the 'Trusts' for your .Net Assemby. We had the same problem
when creating SmartDoc in C#. We had to add the assembly to Trust list
before it would run. (Control Panel/Administrative Tools/Microsoft .NET
Framework 1.1 Configuration). On your development machine you will
automatically get full Trust.

Regards
Lars-Eric