Save Sheet as .xlsm with Usable Macros

[excelschlub]

Hello - I have a mastersheet and run a macro that saves the active sheet as a .xlsm file and creates a shape linked to a macro in this new file. All of that is working fine. My issue is that this macro was created in another book, so when the shape is clicked and the macro is called, there is no macro to run since it was not created in the newly created .xlsm. Is there a way to somehow get the macro code I need to be attached to this shape to be active in the new .xlsm? Or am I chasing a unicorn?

Thanks for any help or suggestions you may have.

-Dave

 

[Fluff]

Have a look at this thread & see if that helps
https://www.mrexcel.com/forum/excel-questions/602413-copy-module-new-workbook-add-button.html

 

[excelschlub]

Thank you! This is a great find. I'm getting close to figuring it out. Many thanks!

 

[Fluff]

Your welcome