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.
  1. the file will ultimately have to be saved with extension .xlsm

I can handle that.

  1. the module in my personal folder will have to be exported, saved temporarily, then imported

I need help with the syntax.
Please Login or Register  to view this content.
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.