Creating custom library of functions/macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 Tools>Add-ins.

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

Gord Dibben Excel MVP
 
Back
Top