Custom Add-ins in Excel: Making VBA Functionality Permanently Available

Package reusable features as an .xlam add-in.

Steps

1. Create a workbook with your modules/forms
2. Save as Excel Add-in (.xlam)
3. Add Ribbon controls (customUI) if needed
4. Install via File → Options → Add-ins → Excel Add-ins → Browse

Auto-run hooks

Use Auto_Open or Workbook_Open in ThisWorkbook to initialize state or menu entries.