I have an Excel based application which loads an Add-in when the control spreadsheet is opened, and then when the user has completed the task, unloads the Add-in as part of the Workbook_Before Close process. The control spreadsheet is closed by clicking the "X" button on the workbook window (not the overall Excel window). The add-in appears to unload correctly, and the control spreadsheet disappears. However, I have now run into a situation where I cannot close Excel itself. Clicking the "X" button elicits a "Not Responding" message, and I have to resort to using the Task Manager to kill the process. This also takes a number of attempts to actually kill the process. The only clue I have is that sometimes, when I restart Excel (2003, by the way), I get a message about a serious problem with the Add-in and do I want to disable them. The Add-in is loaded from a network drive, as is the control spreadsheet.
This is totally new behaviour to me: I thought at first that it might be related to using a version of the Add-in that was modified in Excel 2010 (but not using the .xlam extension), but I think this is a red herring, as the behaviour still occurs with a version of the Add-in modified and stored from Excel 2003.
Any ideasa would be greatly appreciated
This is totally new behaviour to me: I thought at first that it might be related to using a version of the Add-in that was modified in Excel 2010 (but not using the .xlam extension), but I think this is a red herring, as the behaviour still occurs with a version of the Add-in modified and stored from Excel 2003.
Any ideasa would be greatly appreciated