MichaelH
06-08-2005, 05:40 AM
Hi Guys and Gals,
In the Close Event is there a way to tell if this is from the File / Close on the workbook, or from closing the Excel application?
The reason is, I have some code in an Add-In that is executed on the Close event, but I have found a known problem that during the Exel Application Close it unloads Add-Ins before all open spreadsheets are closed; thus depending on what other spreadsheets are being closed and timing, I get spurious fails.
I've already got code that checks that the Add-In exists before a module within it is called, but maybe the add-in unload is happening after that check returns the Add-In does exist.
Any ideas please?
thanks,
Michael
In the Close Event is there a way to tell if this is from the File / Close on the workbook, or from closing the Excel application?
The reason is, I have some code in an Add-In that is executed on the Close event, but I have found a known problem that during the Exel Application Close it unloads Add-Ins before all open spreadsheets are closed; thus depending on what other spreadsheets are being closed and timing, I get spurious fails.
I've already got code that checks that the Add-In exists before a module within it is called, but maybe the add-in unload is happening after that check returns the Add-In does exist.
Any ideas please?
thanks,
Michael