VBA being written to another work book assigning macro incorrectly

[Michael Wise]

I am having a procedure build and write a module into another workbook. The procedure then creates a button in that same workbook and a macro is assigned(the procedure that was built). It does all this but when I use the button it's looking for the assigned macro from the workbook that initially wrote the procedure. How can I get it to call the procedure from within itself. I have the button creation .OnAction = "Button_Click" . Button Click is the Sub that was written by the build and is in the workbook where the button is created.


VBA provided below:

Button Creation Procedure:

Please Login or Register  to view this content.

VBA that adds module & write sub in module:

Please Login or Register  to view this content.

[romperstomper]

Try including the workbook name:

Please Login or Register  to view this content.