Excel 2007 VBA Function - #NAME? error

[ExcelVBA]

Hi Everyone,

NewB here. Been doing prety well with VBA in Excel, but have finaly hit a wall. I have created a worksheet that uses several custom defined functions via Alt + F11.

Everything works as I expect.

However, when i send the .xlsm to another person, then get an error in the cell that uses one of my fuctions "#NAME?" .

When I have them hit Alt-F11, they do see all the functions there however.

-confused

Rob

Thanks!

 

[Tom Urtis]

Maybe their macro security level has not been established and thereby their computer does not recognize the UDFs

or

it could be the UDF itself if it gets produced by a macro that depends on something you think would or should be happening in their workbook but is not.

I'd look at their security level first, it's the more common culprit.

 

[ExcelVBA]

Thank you for the response,

This is what I have tried:

1) Accessed the Trust Center in the Excel Options dialog box. Click the Microsoft Office Button

, and then click Excel Options. In the Trust Center category, click Trust Center Settings, and then click the Macro Settings category.

and then I enabled "Trust access to VBA project object model" under Developer Macro Settings.

quit, save, reopen

#NAME? still appeared when in the cell where I had the VBA function in use.


2) I did same as step 1 above Except check on "Enable all macros" under Macro Settings.

PROBLEM SOLVED! THANK YOU

 

[sparrowsdream]

I ran into this same issue, but the above did not help. Make sure your Module does not have the same name as your Function. This confuses Excel...

 

[baldrick52]

I had this problem. I renamed the module and saved the file. Still saw #NAME . Then i closed the file and reopened it and the function worked.