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
One of the slickest features of Excel — at least in my mind — is the capability to create add-ins. In this chapter, I explain why I like this feature and show you 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.
Any knowledgeable user can create add-ins, but VBA programming ...
Get Excel VBA Programming For Dummies, 3rd 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.