I’m a reasonably proficient user/creator of Excel macros so I foolishly agreed to help a friend “modify a simple Word macro”. Good golly miss molly, the developer interface isn’t even the same.
After entering the sample code in a module, I found out it doesn’t appear on the Developer>Macro tab/menu. And you’re apparently supposed to use normal.docm if you want the macro available to every document?!?!
Is there a quick and dirty Word:Excel comparison table to help get this puppy running?
I’m looking for instructions on using Word macros. Instructions should be directed toward someone with Excel VBA skills, i.e., don’t need to start from ground zero but explain why the user interface for invoking the macros in Word still to be so different from Excel.
I find the user interface and functionality very similar. Word does have the Normal template to which you can attach macros instead of the specific document, but it sounds like your have questions beyond just this.
One of my specific questions is, Why doesn’t the macro appear in the Macro run box unless its written/saved in the normal.docm? I can run it by pressing F5 while in the macro module so I know its a working macro. What’s the trick to getting the macro list run box recognize it?
The macro list box has a dropdown “Macros in:” - make sure you select “All active templates and documents”, or the specific document you saved the macro in.
Also make sure you defined your module as public, not private. And note that you need to save your document as a macro-enabled document (.docm extension).