I've got a really bizzare problem when adding a reference to an Excel addin.
I've got an Excel workbook just over 1MB in size. It contains images, graphs and several VBA code modules.
This workbook has a reference set to an Excel Addin which is about 2MB in size and contains common code used in various places. The addin is installed and therefore loads automatically when Excel is started.
If I don't compile the workbook after adding the reference to the addin, everything seems to work fine. However, if after adding the reference I do compile the VBA project of the workbook and save the workbook I encounter a very weird problem.
If I then open the workbook and close Excel immediately by clicking on the X icon or File->Exit, Excel hangs. This only happens if the reference to the addin has been compiled. If I open the workbook and close only the workbook and not Excel, Excel does not hang.
I'm using Excel 2002(SP3).
I think Excel may be attempting to do something to the addin, maybe close it, and is encountering problems. However I don't see how the reference being compiled brings about this issue.
I know this is an obscure problem so I'd be surprised if anyone knew anything about it but I'd appreciate any insight anyone might have into this issue.
Thanks
AA
I've got an Excel workbook just over 1MB in size. It contains images, graphs and several VBA code modules.
This workbook has a reference set to an Excel Addin which is about 2MB in size and contains common code used in various places. The addin is installed and therefore loads automatically when Excel is started.
If I don't compile the workbook after adding the reference to the addin, everything seems to work fine. However, if after adding the reference I do compile the VBA project of the workbook and save the workbook I encounter a very weird problem.
If I then open the workbook and close Excel immediately by clicking on the X icon or File->Exit, Excel hangs. This only happens if the reference to the addin has been compiled. If I open the workbook and close only the workbook and not Excel, Excel does not hang.
I'm using Excel 2002(SP3).
I think Excel may be attempting to do something to the addin, maybe close it, and is encountering problems. However I don't see how the reference being compiled brings about this issue.
I know this is an obscure problem so I'd be surprised if anyone knew anything about it but I'd appreciate any insight anyone might have into this issue.
Thanks
AA