Chapter 21
Creating Excel Add-Ins
IN THIS CHAPTER
Using add-ins: What a concept!
Knowing why you might want to create your own add-ins
Creating custom add-ins
Reviewing an add-in example
One of the slickest features of Excel is the capability to create add-ins. Excel add-ins make it possible for you to package up your VBA procedures, and make them part of your Excel interface. Best of all, you can share these packages with others so that they get the benefit of your VBA prowess.
In this chapter, you explore how to create add-ins by using only the tools built into Excel.
Okay … So What’s an Add-In?
Glad you asked. An Excel add-in is something you add to enhance Excel’s functionality. Some add-ins provide new worksheet functions you can use in formulas; other add-ins provide new commands or utilities. If the add-in is designed properly, the new features blend in well with the original interface so they appear to be part of the program.
Excel ships with several add-ins, including ...
Get Excel VBA Programming For Dummies, 5th 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.
