CHAPTER 26Creating add-ins
In this chapter, you will:
Learn what a standard add-in is
Learn how to create, install, and uninstall an add-in
Use a hidden workbook as an alternative to an add-in
You can create standard add-in files for your clients to use by employing VBA. After the client installs your add-in on her PC, the program will be available to Excel and will load automatically every time she opens Excel. This chapter discusses standard add-ins.
Be aware that there are two other kinds of add-ins: COM add-ins and Office add-ins. Neither of these can be created with VBA. You need either Visual Basic.NET or Visual C++ to create COM add-ins. You use HTML, CSS, and JavaScript to create Office add-ins. Chapter 27, “An introduction to creating ...
Get Microsoft Excel 2019 VBA and Macros, First Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
