RE: Functions

Hi Jane

The best way to create functions to be used accross all your workbooks and to share is to create all the functions in a new workbook and then save it as an Excel Add-In file. To do this:

1. Create all the Functions in a new empty Workbook

2. When all the functions have been created save the workbook as a Microsoft Office Excel Add-In. It gets saved in the Add-Ins folder of your system:

Documents And Settings/..../Application Data/Microsoft/AddIns

3. Send the Add-in workbook you created to all your colleagues and have them save it in their Add-Ins folder (similar to the above path)

4. When the file has been saved in the folder open excel and click Tools / Add-Ins

5. The new Add-In file appears in the list

6. Tick the box to activate the Add-In file and click OK

The functions you created will be added to the functions list under User Defined.

Hope this helps

Carlos