How to Use Macros in Excel

Step-by-Step Guide

1. 1

   Step 1: Verify that your Excel preferences allow you to run macros.

   This setting is in the "Security" section, in most versions of Excel.
2. 2

   Step 2: Open the workbook that contains or will contain the macro.

   ,, Macros can be run from a menu, connected to a button in the workbook, set to run automatically upon opening a worksheet, or tied to a keyboard command. , To record the macro, find the "Record New Macro�" command.
   
   This can be in the "Macros" section of your "Tools" drop-down menu or ribbon, inside the macro window (again, usually found in "Tools"), or on a toolbar, depending on your version of Excel, your computer system, and your specific Excel setup. ,,,,
3. 3

   Step 3: Verify that macros are enabled in the specific workbook

4. 4

   Step 4: which will let the macro be run.

5. 5

   Step 5: Consider how you want to use the macro.

6. 6

   Step 6: Record or write the macro at this time

7. 7

   Step 7: to repeat the particular process that you want automated

8. 8

   Step 8: if your workbook doesn't already have a macro installed that you want to use.

9. 9

   Step 9: Open the macro menu

10. 10

    Step 10: usually in the "Tools" section of Excel.

11. 11

    Step 11: Test-run the macro you want to use

12. 12

    Step 12: making sure it works properly.

13. 13

    Step 13: Assign the macro to whatever button

14. 14

    Step 14: key command

15. 15

    Step 15: or worksheet auto-run you want to use with it.

16. 16

    Step 16: Run the macro as needed.

Detailed Guide

About the Author