XLplus Add-In Manager

XLplus Ver. 3.X offers a convenient way to handle all Excel Add-Ins currently loaded.

Note: Please do not confuse this tool with the XLplus Add-Ons Manager. The XLplus Add-Ons Manager manages XLplus Add-Ons which are additional tools for XLplus. This tool manages Excel Add-Ins. For details about XLplus Add-Ons see XLplus Add-Ons Overview, for a brief overview about MS Excel Add-Ins see Register XLplus as Add-In.

Using this tool you can save Excel Add-ins from within MS Excel without having to use the VBE.

Additionaly, open Add-Ins can be closed easily without having to restart MS Excel.

With option Convert to Workbook an Add-In can be converted into a workbook and enclosed tables can be edited. Alternatively, use the VBE and set the workbooks property isAddIn.

All converted Add-Ins will be saved within a list. This can be used at later stage in order to convert Workbooks back to Add-ins. You reach this list by Tab Add-Ins converted to Workbooks. There you can use Convert to Add-In to convert it back to an Add-In. In case the workbook is yet not open you can open it with Open Workbook. In case you do not require the list entry anmore you remove it with option Remove Entry from List. Option Refresh List creates the list based on actual data anew. This refreshes the list of loaded Add-Ins, too.

Option Refresh List is of interest in case your Add-Ins were loaded after Add-In Manager had been started.

Add-In Manager lists various properties of the Add-In, i.e. whether it contains VBA Projects or Excel 4 Macro Code, whether parts of the project are protected and more.

Properties

You can sort the listed Add-Ins by clicking the column headers and adjust the size of the dialog.

Note: Add-In Management requires Access to the VBA Project Object Model.

VBA Project Object Model

Social Networks