

COM Add-ins are typically used to automate Excel in response to a click of a CommandBar button, a form or dialog box, or some other event specific to Excel such as opening or closing workbooks or entering data on worksheets.Īctions : Actions make it easier for you to complete some of the most common Office tasks and provide you with more control over automatic features. Once we select an Add-in at the bottom of the window, we see a description of the Add-In as well with the name of the Publisher, the Compatibility, the Location and the Description of it.Īt the bottom of the Excel Options window we see the command Manage, where if we select the drop down menu at the right of the command we have the following options to select from:Įxcel Add-ins: a device or piece of software that can be added to a computer to give extra features or functions.Ĭom Add-ins: COM Add-ins present the developer with a way to extend the functionality of Office applications for custom tasks.

Once selected in the middle of the window we can see all the Active Application Add-ins and all the Inactive Application Add-ins. Once selected the Excel Options dialog box appears, where from the left of the window we select the category Add-Ins. In order to activate them or deactivate them we must follow the steps below.įirst, we must select the File tab in order to move to backstage view and then from the drop down menu that appears we select the Options category from the left of the menu as we can see in the image below. They increase our productivity and get things done very efficiently. An add-in is installed functionality that adds custom commands and new features to Microsoft Office System programs.
