Add-ins - VBA

A VBA add-in is a regular workbook, document or presentation that contains VBA code.
It can add ribbon buttons, custom menus as welll as Excel user-defined functions (UDFs).
VBA is embedded directly into most the Office applications.

Understanding Add-ins

The list of add-ins that are available within Excel is updated every time Excel is closed.
Making changes to the Add-ins dialog box will not save any permanent changes. It will only install or uninstall add-ins on a temporary basis.
To make any permanent changes you must close Excel after you have made your changes.

Microsoft 365

These four add-ins have been available since Excel 2007.
Analysis-ToolPak - This provides additional worksheet functions and data analysis tools.
Analysis-ToolPak - VBA - This allows you to use the additional worksheet functions and data analysis tools directly from your Visual Basic code.
Euro Currency Tools - This allows conversions from the individual member currencies to Euros or to another member currency at the official prescribed exchange rates.
Solver Add-in - This can be used to help optimise a formula based on constraints of its precedent cells.

Third Party Add-ins

ASAP Utilities - asap-utilities.com	General functionality to help automate frequently used tasks.
Code Documenter - appspro.com"	Automatically document the vital statistics of your VBA project.
Excel Utilities - appspro.com"	Helps you to customise the Excel user interface.
Find Link - manville.org"	Searches a workbook for a specified string.
Flex Find - jkp-ads.com"	Lets you quickly search for strings in your workbooks, worksheets and ranges.
Name Manager - jkp-ads.com"	Lets you manage your named ranges in your workbooks and worksheets.
Navigator Utilities - navigatorutilities.com"	Lets you find your way around large (and small) Excel workbooks.
Pattern Fill - andypope.info"	Lets you apply Pattern fills to charts and shapes Excel 2007.
PivotPlay - contextures.com"	Facilitate changes to the connection strings and queries for external source data that pivot tables use.
Rays Tools - grbps.com"	A collection of tools which have been developed to make daily Excel use easier.
VBA Code Cleaner - appspro.com"	Lets you clean your VBA projects by exporting and importing all the components.
XY Chart Labeller - appspro.com"	Add labels to XY chart data points.

ASAP Utilities - asap-utilities.com General functionality to help automate frequently used tasks.
Code Documenter - appspro.com" Automatically document the vital statistics of your VBA project.
Excel Utilities - appspro.com" Helps you to customise the Excel user interface.
Find Link - manville.org" Searches a workbook for a specified string.
Flex Find - jkp-ads.com" Lets you quickly search for strings in your workbooks, worksheets and ranges.
Name Manager - jkp-ads.com" Lets you manage your named ranges in your workbooks and worksheets.
Navigator Utilities - navigatorutilities.com" Lets you find your way around large (and small) Excel workbooks.
Pattern Fill - andypope.info" Lets you apply Pattern fills to charts and shapes Excel 2007.
PivotPlay - contextures.com" Facilitate changes to the connection strings and queries for external source data that pivot tables use.
Rays Tools - grbps.com" A collection of tools which have been developed to make daily Excel use easier.
VBA Code Cleaner - appspro.com" Lets you clean your VBA projects by exporting and importing all the components.
XY Chart Labeller - appspro.com" Add labels to XY chart data points.