I am not sure but it looks like a try to export/import a Data Module (that is the workbook's and the worksheets own code) which is impossible. The only Code Modules which can be ex- and imported are Standard Code Module (.bas), Class Module (.cls) and UserForm (.frm, .frx). The only way to still ex-/import code in Data Modules is to move the code into a Standard Module and just leave the call to it on the original place. So for example in a Standard Module called modWrkbk:
and in the Workbook itself just leave:
The same with code in a Worksheet which may be moved e.g. into a Standard Module called modWshxxx:
and in the Worksheet just leave:
This way Data Modules will no longer contain any code but the call to another Standard Module's public procedure. Data Modules in the end contain nothing but the event procedures ..._Open, ..._Change, ...._BeforeDoubleClick, etc.
Last but not least I recommend to provide each Worksheet with a proper object name (e.g. wshXxxx) and use this throughout the project. This way you not only become independent from the name of the tab which can then be anything meaningfull for the user and even renamed when applicable, but also end up with a much clearer code because instead of
You will say
Bookmarks