In addition, as for removing the “Com Add-Ins”, things are different. Therefore, don’t mix these two different concepts. If you need to delete the add-in from your computer, you need to uninstall the add-ins.
If you need to install other add-ins, you can click the button “Browse” to add it. Here we check the “Analysis ToolPak” in the window. In this window, check the option that you need. And then the window of “Add-Ins” will pop up.Next click the button “Go” next to the “Manage”.Here we choose the “Excel Add-ins” as an example”. Next choose the type of add-ins in the “Manage” textbox.In the “Excel Options” window, choose the option “Add-ins”.Here we will demonstrate the steps to add and disable add-ins in Excel. On the other hand, if you don’t need to use add-ins, you can also disable it. If you need to use add-ins in Excel, you need to add and activate it into Excel.
And in this article, we will introduce how to add and disable add-ins in Excel.
The script will add an “Active Setup” to the computer when the product is uninstalling: Set WshShell = CreateObject(“WScript.Shell”) WshShell.RegWrite “HKLM\SOFTWARE\Microsoft\Active Setup\Installed Components\RemoveExcelAddon\”, “RemoveAddon”, “REG_SZ” WshShell.RegWrite “HKLM\SOFTWARE\Microsoft\Active Setup\Installed Components\RemoveExcelAddon\StubPath”, “C:\Windows\System32\RemoveExcelAddin.vbs ” & Chr(34) & “C:\Hyperion\SmartView\Bin\HsTbar.You can use add-ins in Excel to fulfill some complex task. You need to implement a Custom Action “New vbscript stored in custom action” to the package:
The component which contains this file, must have the following settings: You need to add the file “RemoveExcelAddin.vbs” to a folder at your choice in the package.
It needs the full path to the Add-In as an argument.Įxample: RemoveExcelAddin.vbs “C:\Hyperion\SmartView\Bin\HsTbar.xla”
This is the location where the Excel Add-In registration information will be stored This can be done by using Microsoft Active Setup as the the script we use needs to be executed on each user that operates on the workstation. Remove the Excel Add-In registration information from all user profiles. Excel will try to load the Excel Add-In, even if the file it self has been removed and this will prompt the warning message. That means if the application has been used by different users, there will be the registration part left in the other user profiles. xla), you should start Excel to double-check if an warning message like this appears:Įxcel installs and registers all automation Add-Ins by default in a per user based location, if they are installed via a script or the Excel GUI.ĭuring uninstall process of an application that has installed such an Excel Add-In the process can only uninstall the registration information of this Add-In in the user context that executes the uninstall process. After uninstalling an application that contains a per user based Excel Add-In (.xlam or.