LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Password prompt when closing Excel

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.

"Sergei Didur" wrote:

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.

"john" wrote:

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
turn off 'save' prompt when closing Excel Dawnyanne Excel Worksheet Functions 2 September 18th 07 12:26 PM
Closing Excel - no save prompt Simon Woods[_4_] Excel Programming 3 September 28th 05 03:21 PM
Password prompt appears when closing Excel RJ Lohan[_2_] Excel Programming 3 April 23rd 05 02:13 AM
Excel 2003 when closing Excel after having opened a project locked for viewing.. password prompt??? braindead Excel Discussion (Misc queries) 0 March 25th 05 01:58 PM
Save? prompt when closing Excel MC Excel Discussion (Misc queries) 4 March 12th 05 10:55 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"