Select a solution

  • Create and save all your macros in a single workbook

    Create and save all your macros in a single workbook by creating them in Personal.xlsb, a hidden workbook that opens every time you open Excel. Macros created in Personal.xlsb are available every time...

  • Working with Excel 4.0 macros

    Although the latest version of Excel still supports Excel 4.0 (XLM) macros, we encourage you to migrate them to the latest version of VBA.

  • Always enable macros in a workbook

    Macros are used to automate a repeated task in a workbook. When you open a workbook that has macros, a yellow message bar appears with a shield icon and the Enable Content button. You can allow macros...

  • Run a macro

    Run a macro manually or automatically. This topic shows you several ways to do both tasks.

  • Create or delete a macro

    In Excel, to automate a repetitive task, you can use the macro recorder to quickly record the steps in a macro. You can also use the Visual Basic Editor to write your own macro script in VBA.