How to Share Pushbutton Macros

1. Go to tools> macro> Visual Basic Editor . This launches the Visual Basic editor.

2. What you're seeing at this point is the programming language for macros. The solid lines indicate the end of any given macro.

3. To share any one macro, the "script" for that macro needs to be available to the Visual Basic editor on the destination machine. I'll cover this in step 5.

4. To share all your macros, simply go to file> export file and then save the entire file somewhere, send the file to the destination person's computer, and then run the Visual Basic editor from Word and go to file> import file . You're done, except for getting the macro onto the toolbar.  Note that this method will probably hide or obliterate any MS Office-based macros on the destination machine, so don't use this method unless there are no Office-based macros on the destination machine.  Just open the editor on the destination machine if you're unsure.  If it's empty, you're fine.

5. To share just one macro, copy and paste the script (everything between the two solid lines), then email (or otherwise deliver) it to the destination computer. On the destination computer, open the Visual Basic editor from Word and paste that script into the file. Save. You're done, except for getting the macro onto the toolbar.

6. To get the macro onto the toolbar, use the method you used to get it there after you record a new macro. Go to tools > customize > select the middle tab "commands" > scroll down to macros and select it > then drag the macro onto a toolbar. Customize and /or resize as necessary.

7. Re-Sizing your the icon for Pushbutton Macro is detailed near the end of this video on how to make Pushbutton Macros.