From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Running a macro

Running a macro - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Running a macro

When you want to use a Macro, you will hear the term Playback the Macro, Execute it, Run it, Activate it. The whole idea is you've created a macro and you want to make it work; make it do what it's supposed to do. And when you're getting started with Macros, the preferred method tends to be a keystroke shortcut, but there are other ways as well. Let's create a new macro here and also consider the idea that sometimes the macro you want to create and then Run is stored in such a way that it will always be available regardless of which workbook is open. In this worksheet called PricingSheet, there are a lot of cells with formulas, a lot of cells with just pure numbers. And let's imagine that we want to highlight just the cells with numbers. So let's create a macro here, VIEW tab, drop-arrow or for Macros, choose Record Macro. And we're going to call it something along the lines of HighlightValueCells. Macro names cannot have spaces, this time it will just use upper and lower case value…

Contents