You need to call it with

=Personal.xls!myFunc()

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
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?