Hello, I wanted to ask more about the same question so I am tagging along on
our question.

1. what is the .xla you are talking about? Personal.xla?
2. I have 2 modules in my personal.xls w/ functions in them but they I dont
seem to have acess to them from anouther worksheet.

I wrote a function in WS1.xls

Function CopyFormula(sSumRng As Range) As String
Application.Volatile True
CopyFormula = sSumRng.Formula
End Function

so that when I enter this into a cell on a worksheet
=copyformula("A1")

I get the actual formula and not the result. The only way I can get this to
work is by placing this into a module within the current excel workbook that
I am working in. I too want to put all of my functions in a single file,
personal.xls/xla, so that they are available to any workbook. It sounds like
I need to reference the personal workbook and or the function module to make
this work. How do I do that? Or How do I use the xla extension to shortcut
the solution?

Thanks for the help.