Author: Oscar Cronquist Article last updated on January 22, 2019

Macros and custom functions are great, they can automate many tedious tasks. To have them available whenever you need them, save user defined functions and macros to a personal add-in.

When you open a new excel spreadsheet, these functions and macros are ready to be used.

How to quickly create an empty Add-in for Excel 2007 and later versions

  1. Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder.
    I named it MyAddIn.xlam.
  2. Press with left mouse button on Office button.
  3. Press with left mouse button on "Excel options" button.
  4. Press with left mouse button on "Add-Ins" tab.
  5. Select Excel Add-ins.
  6. Press with left mouse button on "Go..." button.
  7. Press with left mouse button on "Browse.." button.
  8. Select MyAddIn.xlam.
  9. Press with left mouse button on OK.
  10. Make sure MyAddIn is enabled in Add-In Manager.
  11. Press with left mouse button on OK.

Recommended article

Customize the ribbon and how to add your macros

Save links to your favorite macros in a personal tab on the ribbon for easy access and become more productive. […]

Customize the ribbon and how to add your macros

Add custom functions to your personal add-in

  1. Press with left mouse button on "Developer" tab on the ribbon.
  2. Double press with left mouse button on Myfunctions.xlam in project window.
  3. Press with left mouse button on "Insert" tab.
  4. Press with left mouse button on Module.
  5. Copy and paste custom functions and macros to code window.

Take a look at Category: UDFs 

How to use custom functions in an Add-In

  1. Select a cell.
  2. Type the custom function name in formula bar. Press Enter.
    If you don´t know the name of your custom function, continue to step 3.
  3. Press with left mouse button on "Insert Function" button.
  4. Select category "User Defined".
  5. Select your custom function.
  6. Press with left mouse button on OK.

How to use macros in an Add-In

  1. Press with left mouse button on "Developer" tab.
  2. Press with left mouse button on Macros button.
  3. Type the name of your macro.
  4. Press with left mouse button on "Run" button

Example custom functions and macros

Which macro shortcut keys do you use? (Code for excel and outlook)
Personal.xls (Daily dose of excel)
User defined functions (Get Digital Help)

Recommended blog posts:

Excel Macro Toolbar
Menu for favorite macros in Excel 2007-2010 (for all workbooks)
Making Your Custom Functions Available Anywhere