Intro to Excel 2010 Macro Tools

 

Basic overview of the tools needed to use VBA. By default, VBA tools are hidden. It is required that you complete the steps below to change a setting in Excel options to access the Developer tab.

  1. Open File menu to get to the new Backstage view.
  2. On the left navigation bar, select Options under Excel.
  3. In the Excel Options dialog, from the left navigation, select Customize Ribbon.
  4. In the Right list box, Select the check box next to the Developer tab located third from the bottom.
  5. To return to Excel, click OK

 

 

Icons used for recording and playing back VBA macros in the Code group on the Developer tab: