Add-Ins contain Visual Basic code for automating operations in any of the main Microsoft Office business packages - Word, Excel, Access etc.

Add-Ins are files just like Excel workbooks - indeed they are normally created from Excel workbooks.

They can be opened and 'run' in the same way as any normal Excel workbook. Since they contain vba program code, the user will frequently be greeted with a Microsoft Office message like.

While you should be careful about the Add-Ins you run on your computer, there is no point in opening an Add-In unless you are prepared to 'Enable Macros'. It won't work otherwise.

Excel has a special method for loading Add-Ins whenever it is initiated.

• See - Loading Add-Ins
  

This method has the advantage that the user will not be confronted by the above message each time it loads.

Add-In files do not contain any visible worksheets and in general you are not permitted access to the macros they contain from the 'Macros' button on the standard 'Tools' Menu.

For each Add-In you load you must identify the method that the programmer has provided for using it.

Remarks

For more details about ACBA Electronic Working Papers our website contains general descriptions and additional information.