User Defined Functions as AddIn

Good morning to everyone.
I posted a question yesterday at
http://www.excelforum.com/showthread.php?t=601728
and the response worked perfectly.

My problem is that I would like to turn my UDF workbook into an addin.

I have placed the UDF code into a module, E.g.

Please Login or Register  to view this content.

In the regular workbook I can place the code for adding the functions to the Insert Function dialog into the This Workbook Open Event

Please Login or Register  to view this content.

Or I can place the code into a module as a subroutine (addFunctions) and call it from the Workbook Open event

Please Login or Register  to view this content.

All works as it should.
When I save as an addin, I can install the addin and all works.

But as soon as I close out of Excel and open a new Excel window, I get the error message

Please Login or Register  to view this content.

I have deleted the addin, changed the code in the workbook (as above), saved again as an addin, etc.

Everything still results in the same error when I completely close out of Excel and open a new instance.

The code that is high lighted when I click to debug is

Please Login or Register  to view this content.

What is the proper way of having these functions installed?

I just kept trying different things.

I don't know if this is the accepted way of accomplishing the objective, but it worked for me.

The solution was to add a couple of lines at the beginning and at the end of the Workbook_Open

Please Login or Register  to view this content.