Note to add to Bob and Dave's responses.

If you place the macros and functions in an add-in you will not have to preface
with the filename

=myFunc() will be sufficient.


Gord Dibben MS Excel MVP

On Thu, 7 Sep 2006 17:26:06 +0100, "Bob Phillips" wrote:

You need to call it with

=Personal.xls!myFunc()