I currently have a macro that inserts a button on a file and assigns a macro to it from my personal folder.
I also have the same macro set up to send an email with the file attached. From my research it appears a couple things have to happen in order for this to work out.
- the file will ultimately have to be saved with extension .xlsm
I can handle that. 
- the module in my personal folder will have to be exported, saved temporarily, then imported
I need help with the syntax.
The bottom line is I want whoever receives the email with the file to be able to press the button and have the button carry out its code without a hitch.
I also want to mention this just in case: I want the macro in my personal folder to remain untouched. So, if export=cut instead of export=copy, then that's not good. 
Another note: yes, I have checked the "Trust access to the VBA Project object module" as well as checking the ...Extensibilty 5.3 thingamajig.
Bookmarks