Disclaimer: These instructions pertain specifically to Excel 2007.
If I were to do that, I would copy the macro code into a text file and email it to the recipient. I would then pay a visit to their workstation and ask them to open their email and an Excel session. Next, I'd begin to record a macro then immediately cancel the macro recording. Then I would enter the VBA editor and paste the code into their personal macro workbook. Finally, if they wanted quick access to that macro, I would click the Quick Access toolbar and choose Quick Access Toolbar. Choose More Commands, then Choose commands from: Macros. Find the macro, click the Add button and click OK to close the toolbar customization dialogue.
Yep, they will.
The instructions would only be different if you were using 2003 or earlier.
'bout the only thing I'd add would be when recording the macro, type something simple in a cell, like "Hello", so the macro has content and then copy the text file over the "hello" line
Sorry for being unclear on that. It was a Friday afternoon and I had like 10 minutes before I left the office. I knew that the steps would basically work in 2010, but I wasn't sure if the references to the QAT might be different under the 2010 interface. Thanks to Michael M for clarifying.