UDF doesn't appear in Insert Function list

[Bodyworker]

I created two functions. One I can access with no problem from the drop-down menu. The other I can't. The function's name is SimonCost, but what appears on the list are two names: SimonCost.SimonCost and module1simon...

Looking at the functions, they appear identical from a format standpoint. I can't figure out why one is usable and the other isn't. This isn't a formula-related issue.

Help!

[davesexcel]

can you show the code?

[Bodyworker]

Function SimonCost(Hours As Double)

SimonCost = 6.74 + (0.48 * Hours) + (1.03 * Hours) + (2.89 * Hours)

End Function

[davesexcel]

Could you have SimonCost UDF in two different modules?

[Bodyworker]

Nope. I'm thinking that the reason the function doesn't work is because it's not being automatically saved correctly (hence its absence in the function list) because it's such a simple calculation. I could just stick it in the cell and be done with it, but... I'm perplexed

[davesexcel]

if there are two of them then delete one, it won't work if there are two of them

[Bodyworker]

Dave,

I figured out my problem, but not how to fix it. And cos I'm a total forum newbie, I retitled my issue instead of just posting a reply to this thread. My bad. Anyway, I've distilled it to this: when I create a local function I can't use it as such. The function is being saved with the workbook title as a prefix and I don't understand why.

Thanks for your patience.