How to edit a macroRead Now
In Macro baby steps part ii – Recording your own macros, I mentioned that macros can be edited. In fact, being able to edit macros is one of the great things about them, so it’s quite useful to understand enough about how macros work to have the confidence to tweak your own macros – and other people’s.
Macro baby steps seriesRead Now
Here are the links to the posts in the series:
Macro baby steps part iiiRead Now
How to use your macros without really noticing you're using macros
This is the third of a series of posts for people who would like to use macros, but who find the mere thought extremely daunting. In Macro baby steps part i, I recommended a few simple macros to start your macro journey with, and in Macro baby steps part ii I talk you through recording your own macros.
In the What is the Quick Access Toolbar? post, I described how to add a Word command to your Quick Access Toolbar. Here, I explain how to add a macro to the Quick Access Toolbar as there are a couple of extra steps that you need to do.
Word comes with a few pre-assigned keyboard shortcuts: most of us are familiar with saving using CTRL+S, cutting with CTRL+X, and pasting with CTRL+V – and we wouldn’t be without CTRL+Z to undo our typos! Word also allows you to assign your own keyboard shortcuts for Word commands, macros, symbols and styles, among other things …
The Quick Access Toolbar is a handy place to keep your most frequently used Word features. It's a feature of all Microsoft Office products, but it's not something that I have made use of in anything other than Word.
If you haven’t added anything to your Quick Access Toolbar, you will probably find it on top of your ribbon looking something like this:
Word: How to install a macroRead Now
There are (at least) a couple of ways to install a macro. I will talk you through what is probably the most straightforward method later in this post, but first let us look at what a macro looks like inside Word’s Visual Basic for Applications (VBA) editor. (I'm going to skip the 'for Applications' bit for simplicity.)
The Developer tab doesn't always appear automatically when you install Word. You might find that your Word ribbon may look like this:
Andrea at Yours Truleigh Editing