Every time I launch Excel365 with my main add-in already running, I would need a global solution.
In my add-in, I created a number of LAMBDA custom functions that I would like to make available globally, not only for the current workbook. Can it be done? The formulas are not available even though I tried to save a workbook with the definition as an add-in (.xlam). They don't appear to be an add-in option when. All is well and running while I'm in the add-in parent file on the desktop. The Lambda(s) and the defined namespace, however, vanish whenever I publish the file back for you to use as an add-in.