You can create a personal.xls or addin.

Record a new macro and select Store Macro in Personal Macro Workbook.
You can then open up your other workbooks and copy the functions over .

Jon

sclark wrote:

Is there a way to create a library of custom functions and macro's that can be used globally by all workbooks opened? I currently keep all of these things in one workbook, and just open that workbook to use the functions or macros. I'd like to NOT have to do it that way. Any suggestions?

Steve



--
42°57N 81°16W