Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In the last lesson, we recorded a macro and now it's time to play it back. Now if you skipped to this lesson, you can just watch or go back a lesson and then follow along. Our scenario was this job posting document where we added a center closing at the bottom. Now we're going to do it for another posting. So let's go to our Office button, we'll click open, navigate to the lesson 15 folder, and that's where you're going to find posting 15B, give it a click, and click Open. Okay, so this is another job posting for a different position and you can see down at the bottom we don't have our closing text.
So we click down here. And this of where we want to add it, but we don't want to have to type it at the bottom of every one of these documents. That's why we recorded the macro so instead of typing our final text we're going to use that macro that we created to save some time. So let's go up to our Quick Access toolbar, we did create a button, as I hover over it you can see it says posting footer. That's what we renamed it to. And when I click it, look at that, my text goes in very quickly. It's centered and my document just got saved as well. I'm done. That was fast.
Now if we had chosen to make our macro run from the keyboard shortcut instead of a button, we would press the keys we assigned and get the exact same result. For example, with closing text for a posting like this, well, maybe we would be used to Control + Alt and C as a shortcut and you press those three keys and boom! There it is. Regardless of whether you assign a button or keystroke combination, just imagine doing a large number these documents and how much time will be saved thanks to this macro. And just so you know, you don't have to live with your macro if you don't like it.
That's right, you can change it if you have to. We'll discuss editing a macro next.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90578 Viewers
80 Video lessons · 137945 Viewers
59 Video lessons · 56687 Viewers
52 Video lessons · 70307 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.