Excel® 2013 VBA and Macros

26. Creating Add-Ins

In This Chapter

Characteristics of Standard Add-Ins

Converting an Excel Workbook to an Add-In

Having Your Client Install the Add-In

Closing Add-Ins

Removing Add-Ins

Using a Hidden Workbook as an Alternative to an Add-In

Next Steps

Using VBA, you can create standard add-in files for your clients to use. After the client installs the add-in on his PC, the program will be available to Excel and will load automatically every time he opens Excel.

This chapter discusses standard add-ins.

Be aware that there are two other kinds of add-ins: COM add-ins and DLL add-ins. Neither of these can be created with VBA. To create these types of add-ins, you need either Visual Basic.NET or Visual C++.

Characteristics of Standard Add-Ins