I really like your idea of having a macro to "turn on" my add-in, instead of exposing some new COM interface from the add-in to do this.
One difficulty I am having is that the macro must be a static function, while the add-in gets instantiated. How do I get a reference to current instance of the add-in from within the static function?
I also wanted to try out the latest code from the code repository (v. 75950), so I plugged-in that latest ExcelDna.Integration.dll and ExcelDna.xll and while the plugin shows up as loaded in Excel's list, it does not run AutoOpen() and AutoClose().
Reverting back to the versions of those files from ExcelDna-0.29.zip makes the plugin work again. Any idea why I am seeing this behavior?
One again, thanks a lot for your help.