Open file behavior with add-in
I have written an add-in that when it is loaded, Excel will
not load a file that has been double clicked unless Excel is
open already. If Excel is not open the file will not load
although Excel does not load a default blank spreadsheet as it
does if I load Excel directly. (This is not the well known
uncheck the ignore other application box problem.) If the
add-in is not loaded everything works fine. I have other
add-ins loaded that do not affect the behavior so I am
reasonably sure that it is something in my add-in that
causes the problem.
Most of the code is a module (over 5000 lines). A little
is in this workbook module and a little is in forms
modules. Since there is a lot of code it is difficult to
know where to start looking for the problem. Can anyone
suggest where I might look or even better if you suspect
you know where the problem is can you tell me. Thank you.
Pieter Vandenberg
|