Home / MS-Excel / General Formatting

Excel Macros

Macros enable you to automate almost any task that you can undertake in Excel. By using Excel's macro recorder to record tasks that you perform routinely, you not only speed up the procedure considerably (as Excel can play back your keystrokes and mouse actions much faster than you perform them manually), but you are also assured that each step in the task is carried out the same way each and every time you perform the task.

Macros are programmed procedures that are written using the Visual Basic for Applications (VBA) programming language. The words macro and procedure are used interchangeably.

In this tutorial, you get a chance to practice recording, testing, and playing back macros that you use to automate repetitive tasks required when building and using your Excel worksheets and charts. You also have the opportunity to practice assigning the macros you record to custom menu items and toolbar buttons.

In this tutorial:

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