I have written an add-in with several public functions that work fine when
used in a formula in a cell. But, when I save the workbook, close Excel,
reopen Excel and open the workbook the formulas evaluate to #VALUE!. If I
hit recalc it does nothing. If I reenter a formula or enter a formula in a
new cell it works fine. How do I get the add-in to run my functions and show
the result when it Excel opens or when a new workbook opens?

Thanks,
John Hutchins