Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets

Chapter 18. Building Add-Ins

Create an Add-In

With add-ins, you can integrate additional functionality into Microsoft Excel. You can create an add-in and use it to add user defined functions, custom dialog boxes, Sub procedures, and custom Ribbon tabs to workbooks. Add-ins are a great way to integrate your procedures into any Excel workbook.

You create an add-in by saving a workbook in the add-in format. By default, Excel places add-ins in a special AddIns folder.

After you save a workbook in the add-in format, the worksheets in the workbook are no longer visible and you cannot make them visible by using the Unhide command. You cannot see or edit the sheets in an add-in workbook. In addition, an add-in workbook does not become a part of the Workbooks ...