From the course: Excel: Macros in Depth (Microsoft 365)
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 from the Developer tab or the View tab
From the course: Excel: Macros in Depth (Microsoft 365)
Running a macro from the Developer tab or the View tab
- We're looking at a workbook called Menu Playback, and it's a reminder that we can playback a macro if we forget its keystroke shortcut, or maybe it doesn't have one, or if we're just not familiar with whether this workbook has macros in it. We can always go to the view tab in the ribbon, click the macros button, and then, making sure that we're only looking in the current workbook, in the lower portion of this dialogue box, we'll choose this workbook. There is a macro in this workbook, only one, and there it is. Sometimes we forget whether there's a macro in the workbook, sometimes we're not sure what it is, sometimes we're checking to see if it has a keystroke shortcut by clicking options. We can always come to this location. Another way to come to this same choice is by adding a new tab into the ribbon menu system. If we right click any tab, for example, view, and choose customize the ribbon, in the Excel options…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.