Thanks Rob,

I knew I was missing something obvious. I just forgot the "Automation"
button was on the Add-ins dialog

Rob van Gelder wrote:
HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions
http://support.microsoft.com/default.aspx?kbid=285337