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

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

Steve

Move/copy them to your Personal.xls

If you don't have a Personal.xls, start the Macro Recorder, select Personal
Macro Workbook to store it in then record a small macro.

Place your macros and Functions in modules in this workbook. You will save it
as "Hidden". It will open in the background when Excel starts up.

Second method, which I prefer because you don't have to preface the macro name
with the workbook name.

Move them to modules in a new workbook and save it as and Add-in(*.xla) which
can be loaded through ToolsAdd-ins.

Note: these macros will not show up in the ToolsMacroMacros list. When
assigning to buttons or menus, just type the name in the dialog box.

Gord Dibben Excel MVP



On Fri, 23 Jan 2004 12:51:06 -0800, 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