Excel Video 407 will make your macros easier to access. While you may occasionally write a one-time macro to solve a messy problem on a complex spreadsheet, many of the macros you write will be tasks you want to repeat over and over again. We’ve already talked about creating keyboard shortcuts to run macros in Excel Video 403. Today’s Excel Video shows you how to attach macros to the Quick Access Toolbar and to the Ribbon. You can create a new tab on the Ribbon, which we’ll do in this Excel Video. You can also add a group to an existing Ribbon tab. We’ll also discuss creating a personal macro workbook to store macros to use across multiple spreadsheets.
Stay tuned. In the next Excel Video, we’ll add macros to buttons to make it easier for new Excel users to run macros.