Transferable Macro

[mbesspiata]

Is it possible to have a macro attached to a file so that when someone sends the file to another person, it is capable of being run for the other person?

 

[Fluff]

As long as the macro is in the workbook that is being sent, then yes.

 

[Joe4]

Just note that if you are emailing the file, some email programs/settings may strip the VBA code from the file (as a security measure).
And it is dependent on the user on the other side enabling the macros when they open the file.

 

[mbesspiata]

Thanks for the response.