XLS 2007: UDF not found

[vsoler]

Hi,

I am developping some simple UDF functions in my XLS 2007 model. I am
using a xlsm file.

However, very often, a UDF in the grid does not seem to find the
correspoding UDF definition in the macro editor since I get a #REF!
error. It seems to me that macros/UDF are disabled. How could I enable
them?

Thank you

 

[Gary''s Student]

If Excel can't find a UDF, you would see a #NAME! error, not #REF!.

To enable macros without changing security level, click on the warning and
enble the content.