I have an excel workbook of xlsb format (let's call it "Child-workbook") automatically generated by another excel workbook ("Parent-workbook"). This so called "Child Workbook" has some sheets, containing graphs. I want these sheets to have a code that runs each time the user selects the sheet, and I want the "Parent Workbook" to transfer that code to "Child-workbook". The transfer has been done succesfully, the module does appear in the Child workbook's project until I close it (of course I save it before that...).

This is how it looks like after saving, before closing the Child workbook:

Code1.jpg

My problem is that when I reopen the Child workbook, the module is still there though, but its content is completely gone, it's empty.
This is how it looks like after reopening Child workbook:

Code2.jpg

Here is the Code of the Transfering module of Parent and beneath that the code of the Module itself to transfer (unfortunately I failed to insert it in the normal way, so I did it in JPG):

coding.jpg

I already tried to save the Child to xlsm format, did not work.
Any other advice is very much appreciated.