Password prompt when closing Excel

[Sergei Didur]

I am developint COM addIn for excel 2003 using C# and .Net 2.0 interop.
In the code I am sibscribing to excel events like open, activate, etc.
It looks like it causing problem with any VBA addin installed that uses same
events.

For example if you have "Lookup Wizard" addin from Microsoft - after you
click Tools\Lookup so wizard form is shown, when Excel is closed you would
get password prompt. If you don't open any VBA addin form - then not prompt
will appear.

All objects in my addin are disposed and cleared (including events), host
app domain is closed, but password prompt still appears.

Any idea what could be the problem ?

 

[john]

Microsoft help & support site have an article on this subject which may help.
http://support.microsoft.com/kb/280454

 

[Sergei Didur]

It does not apply to my case.

I am having problem with any VBA AddIn including the ones created by
Microsoft (unless they are not following their own recomendations).

The problem only occurs when .Net add-in and VBA add-in subscribe to the
same Excel event and VBA add-in shows any form.

It looks like a bug to me.

 

[Sergei]

It looks like there is a bug in
Microsoft.Office.Interop.Excel.AppEvents_Event class implementation - it does
not close events sink properly.

So, solution is to implement disposable event sink class based on AppEvents
interface by yourself and connect to Excel events sink using
IConnectionPoint.Advise method.

In Dispose method you would need to disconnect using
IConnectionPoint.Unadvise() method.