1. what does the .xla do for me? Personal.xla?
2. I have 2 modules in my personal.xls w/ functions in them but I dont seem
to have access to them from another worksheet.

I wrote this function

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.