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

Running a macro from the Developer tab or the View tab

From the course: Excel: Macros in Depth (Microsoft 365)

Start my 1-month free trial

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…

Contents