User Defined Function is not working for me in Excel 2007

A

Abdi

Hi,
I've trying to practise VBA in Excel 2007. But when I enter the UDF I'm
getting #NAME? Anyone can help me where the problem is?
Regards
Abdi
 
D

Dave Peterson

Did you allow macros to run when you opened the file that contained the code?

Did you put the UDF code in a general module--it doesn't belong in a worksheet
module or behind ThisWorkbook.
 
Top