09-17 Run an Excel macro from a button control

In this lesson you'll learn how to run an Excel macro from a form button control. This is done in the context of a real-world business payroll workbook. The lesson walks you through recording three macros and then adding buttons to execute them. You'll also learn many other macro-related skills along the way including how to execute a macro from the Quick Access Toolbar, how to correctly record macros and how to save a Macro Enabled Workbook. Note that you must have the Developer tab enabled on the Ribbon to complete this lesson. If you are unsure how to do this you will need to revise Expert Skills Lesson 09-01: Add group box and option button controls to a worksheet form (https://youtu.be/ELHlVZ0dL_M). As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson. ⌚ Timestamps 0:00​ Sample file download instructions, download link, and discussion of sample workbook. 0:17 Show each of the three custom views in the sample workbook using the Ribbon. 0:42 Discuss how the workbook can be made more usable with button controls. 1:02 Create three macros for each of the actions the buttons will trigger. 3:39 Test the three macros to ensure that they work correctly. 4:24 Add three button form controls and associate each with the macros. 6:29 Test the buttons to ensure that they work correctly. 6:58 Discussion of the many ways in which macros can be executed. 7:35 Demonstration of how to execute macros from the Quick Access Toolbar. 10:12 Save the workbook as a Macro Enabled Workbook. 10:36 Link to next lesson, course session playlist and to download sample file set.