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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
User Defined Functions 2
Excel - Wich Function should I use? 1
Incorporating the User Profile location into a document template path 1
Template with fields and premade texts.. 0
Excel does not accept text format! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top