I have a report that generates every morning from my headquarters. I have created a macro that I run on that report. One of my employees gets the same report, and I would like to give her the same access to my macro, without having to recreate it on her machine. Some notes --
1) I cannot load the macro on a flash drive -- we are a bank. Our PCs don't like flash drives.
2) I cannot e-mail it to her in an unusual format. See above with bank security restrictions.
Therefore: I'm pretty sure I have to cut-and-paste from the VB Editor and put it on her machine. I just don't know how to do this gracefully. Also, it's a skill I have to learn because I make occasional changes to the macro, so I need to know how to do this more than once.