#NAME? error for UDF

I have created a UDF for doing a simple calculation for my colleague. I have tested it and it works fine in my own file (.xlsm). So I copied it and pasted into a module in my colleague's file (also .xlsm) but I keep getting a #NAME? error when calculating it. It is inserted in a module that has a different name from the function itself and everything is copied exactly to his file, but I still get the problem and I don't know what the difference is. We're both running Office 2007. Can anyone tell me what I'm doing wrong?

This is the UDF:

Please Login or Register  to view this content.

Copied into a standard module, it works fine for me.

I can get a #NAME? error if I create a second identical code module ... but I get Ambiguous Name detected, so that's pretty obvious.

I get a #NAME? error if the function call in the worksheet is spelt wrong.

I don't get a #NAME? error if I make it a Private Function or a Private Module.

But I do get a #NAME error if I put the function in a Sheet class module.

So, some options to look at ...


Regards, TMS

also if you have macros disabled ;-)

@JP: Ah, never thought of that. Started out in an existing workbook (without code) and just pasted the code in ... obviously, I could then run it. I'll be annoyed if that's the answer.