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 ...