Once a macro is created, where is it stored on the computer? I need to copy one I created and send it to another person here at work.

Mike

The problem you might have at work, is that some networks are secured in such a way that macros will not transfer over the them in documents. Therefore, it may be simplest to copy the macro coded directly.

Word stores macros in doucments and templates; the default sends a new macro to the Normal template, Normal.dotm. There are various ways to share macros. Here's one:

With Word open, when you press Alt plus the F11 key, the Visual Basic editor will open, and you can copy any macro from there. Look in the top left-hand panel called Project, and double-click on the icon to the left of New Macros, which may be concealed at first in the Modules folder (double-click to open folder, as usual). This should show your macros in the right-hand pane, unless you hgave stored them elsewhere. You need to select, beginning with the line that starts with "Sub" and includes the name of your macro, down to where you see the line "End Sub", before the horizontal line (if there is one). Copy this and paste it into an email or Word document to send your friend. He or she can then copy the same code, open the editor as you did, and paste the macro at bottom of the list,being sure to click on the familiar Save icon before exiting.

Best,
Ulodesk