This is in 2007.
I have a UDF in a workbook that works fine when I first enter it in a formula. However, when I close then later re-open the workbook, every formula gives a #VALUE! error. The formula is only a call to the UDF. When I click F2 then hit Enter without changing anything to force reevaluation, the formula gives the correct result. Pressing F9 to force recalc has no effect.
I have Medium security level on macros, so I am prompted to allow them to run when the file opens. I click the Options... button then "Enable this content". The UDF will not be allowed to run on file open, and I am wondering if it is not automatically forced to run when I then allow macros to run.
(The UDF looks at the indent level of the adjacent column to calculate an outline number for a WBS.)
Is there a way to have the function run when I open the file, or at least a way to force it to run after I have enabled macros, without visiting each cell?
Bookmarks