Thread: Macro
View Single Post
 
Old 03-17-2011, 09:58 AM
Ulodesk Ulodesk is offline Windows 7 32bit Office 2007
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 872
Ulodesk is on a distinguished road
Default Macro

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
Reply With Quote