MS-Excel / General Formatting

Macro Key Tips

  • Macros are handy tools you can use to perform repetitive tasks quickly, such as inserting blocks of text.
  • You don't have to be a programmer to use macros; you can record your actions and have Excel 2007 save them as a macro.
  • Excel 2007 uses macro-enabled workbook types, which have the file extensions .xlsx (a macro-enabled workbook) and .xlstx (a macro-enabled template workbook).
  • If you are curious about what a macro looks like, you can display it in the Visual Basic Editor. If you know a little VBA, or if you just want to experiment, feel free to modify the macro code and see what happens.
  • You can create Quick Access Toolbar buttons and shapes that, when clicked, run a macro.
[Previous] [Contents]

In this tutorial:

  1. Excel Macros
  2. What You Can Do with VBA Macros
  3. Introducing macros
  4. Displaying the Developer Ribbon
  5. Creating a Macro
  6. Running a Macro
  7. Assigning Macros to the Quick Access Toolbar
  8. Using a Function Macro
  9. Saving and Deleting a Macro
  10. Macro virus protection
  11. Macro Key Tips