I have created an Add-In, by openning the VBA, inserting code into a general
module and then saving the workbook as a Excel Add-In. I then added the file
to my Add-Ins through Add-Ins manager. The formula works yeah!, but doesn't
show in the list of available formulas as I type.

I would like to roll this out to other users in my office.

Thoughts?