#Name Error on User Defined Function

[Chick3nD3m0n]

I am having the same issue as the user that posted this thread:

Excel 2007 : #Name? on Excel 2007 user defined function

I have a UDF that works consistently (been using it for a few weeks). Then, all of the sudden, I will open the spreadsheet, enable macros, and the UDF will return #NAME in all cells it applies too. Other UDF's still work and I tried the solution in the linked thread. The msgbox appears so I know that the macros are enabled. If I change the name of the UDF and change it in all the cells it works again. However, this is super annoying. . .

[Kyle123]

Is it in a module and have you declared it as public?

[Chick3nD3m0n]

Yes to both. As I said, up until today it had worked fine.

[Chick3nD3m0n]

Ok, so I figured out that the error is stemming from when I name the module in the properties window of VBA (F4). How can I name the module and have the spreadsheet still be able to find it?

[MrShorty]

I have never had trouble naming a module, unless I used a reserved name, or used the same name for the module as for one of the functions. If it seems related to naming the module, make sure you aren't creating some kind of name conflict.