|Didn't we cover this in your other thread entitled: "copy file from microsoft excel2010 to another workbook"?|
I'll repeat what I posted in that thread:
"Yes, you need to enable macros in order for the UDF's to work.
As long as you have a decent anti-virus program installed and running, you shouldn't have to worry about setting the macro security to Low. The warning about it being "Not Recommended" is Microsoft's way of protecting themselves because they have no way of knowing to what extent your machine is protected.
Of course, it's easy for me to tell you to set it to Low without knowing about your virus protection because I doubt you'll come after me if some dangerous code ends up on your machine. Ultimately it's up to you to protect your machine(s) against viruses and malware.
Keep in mind, that if you give this workbook to other users, they too will need to enable macros in order for the UDF's to work for them. You can't force them to enable macros via any kind of code or Excel function, they have to do it themselves.'
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.