There's NOTHING special about 'Personal.xls', except
that it's the default name that XL uses in the Record Macro
dialog (for WinXL, MacXL defaults to 'Personal Macro Workbook').

Which is why I explained it the way that I did.


--
Biff
Microsoft Excel MVP


"JE McGimpsey" wrote in message
...
Note that you don't have to store it in a file called Personal.xls.

There's NOTHING special about 'Personal.xls', except that it's the
default name that XL uses in the Record Macro dialog (for WinXL, MacXL
defaults to 'Personal Macro Workbook').

You can store it in a file with ANY name that's placed in your Startup
folder (with the window hidden, if desired, as XL creates Personal.xls).
Use the filename as a prefix to the UDF name.

OR you can save the file with the UDF as an Add-in, and you don't need
the filename prefix when the add-in is loaded (either through the
Tools/Add-ins menu, or just store the Add-in in your startup folder).

In article ,
"T. Valko" wrote:

To make a UDF available to all workbooks you have to store it in a
special
file called Personal.xls.