Saturday, September 1, 2012

How to quickly create an empty add-in for excel 2007


How to quickly create an empty add-in for excel 2007

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

Add custom functions to your personal add-in

  1. Click "Developer" tab on the ribbon.
  2. Double click on Myfunctions.xlam in project window.
  3. Click "Insert" tab.
  4. Click Module.
  5. Copy and paste custom functions and macros to code window.

No comments:

Post a Comment