Yesterday was my first day at a new job and first day with excel in vista.

I created 3 user-defined functions, and each of them appeared to work in the
sense that they generated numbers. I was planning on testing them today.

but today I get #NAME for all of them. I have gone into the "trust center"
and enabled "trust access to the teh vba project object model". This doesn't
help.

Also, if I start to type the name of the user defined function, I see a
suggested function that has the same name below it in red. Very promising. So
I click on that. But when I click on the fx key, it doesn't prompt me for
arguments, because it no longer recognizes the function.

Any idea what's happening or how to get my user-defined functions back in
action?

Thanks.
--
Steve