Excel Not Seeing User-Defined Functions

D

David Fabian

Does anyone know why Excel sometimes does not see
user-defined functions, and instead fills the cell with
"#NAME?"?

(I have run across this problem before, but I do not
remember what smack-in-the-head Excel requires.)
 
D

Dave Peterson

Did you enable macros when you opened the workbook?

And are these UDFs stored in the same workbook or a different workbook/addin?
 
D

David Fabian

Dave Peterson said:
Did you enable macros when you opened the workbook?
Click to expand...

Yes. I even set the macro security to "Low".

And are these UDFs stored in the same workbook or a different workbook/addin?
Click to expand...

They are in "Module1". One time, Excel did not see my user-defined macros stored
in the worksheet's module, so I moved them to "Module1", and Excel suddenly saw
them; but that is not an option here.

UPDATE: I just found a new way to make Excel see my user-defined macros: I
simply recorded a new macro, then Excel suddenly saw them.

Thank you for your help.

Dave
 
Top