What does your formula look like when you try to use the UDF in personal.xls

Does it look like:
=personal.xls!myFunction(a1)



wrote:

I have written a function that works fine if I add it to a module for
that particular worksheet. When I add it to a module in my personal.xls
sheet so I can use it on anything I open I get the #Name error. Any
suggestions?

--

Dave Peterson