Skip to search results
PRODUCT
Office.com results
Edit a macro
Article To edit a macro, use the Visual Basic Editor (ALT + F11). To edit and run macros, you must change your security settings to temporarily enable all macros.
Excel 2010
Run a macro
Article In Excel 2010, after you record a macro, you need to run it to make it work. The Run button is in the Macro dialog box (Developer tab, Code group).
Excel 2010
Create or delete a macro
Article Macros can help you automate repetitive tasks and save time. You can use the macro recorder to record the macro or write your own macro script in VBA.
Excel 2010
Macro Error
Article Show All Hide All The Macro Error message appears when there is an error in the macro (macro: An action or a set of actions that you can use to automate tasks. ...
Excel 2010
Copy your macros to a Personal Macro Workbook
Article To reuse your macros, you need to copy them to a special workbook on your computer called a Personal Macro Workbook (personal.xlsb).
Excel 2010, Excel 2007
Save time by creating and running macros in Excel 2010
Training In this training, you'll learn how to record, run, and edit a macro, and how to save a macro to your personal macro workbook so you can reuse it later.
Excel 2010
Copy a macro module to another workbook
Article To copy a macro in an Excel workbook to another open workbook, you use the Microsoft Visual Basic Editor.
Excel 2010, Excel 2007
Quick start: Create a macro
Article If you have tasks in Excel 2010 that you do repeatedly, you can record a macro to automate those tasks.
Excel 2010
Working with Excel 4.0 macros
Article Although Microsoft Excel 2010 still supports Excel 4.0 (X LM) macros, we encourage you to migrate them to the latest version of Microsoft Visual Basic for Appli...
Excel 2010
Create or delete a macro
Article 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 writ...
Excel Online
Quick start: Create a macro
Article Create a macro, run the macro, and edit the macro code. Macros can save time by automating tasks and data entry.
Excel 2013
Run a macro
Article Run a macro manually or automatically. This topic shows you several ways to do both tasks.
Excel 2013
Copy a macro module to another workbook
Article Copy a macro from one Excel file to another by using the Microsoft Visual Basic Editor.
Excel 2013
Create or delete a macro
Article 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 writ...
Excel 2013
Create and save all your macros in a single workbook
Article 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 i...
Excel 2013
Macro Error
Article The Macro Error message appears for several reasons. This topic lists the reasons and provides basic troubleshooting.
Excel 2013
Working with Excel 4.0 macros
Article 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.
Excel 2013
Edit a macro
Article Use the Visual Basic Editor on the Developer tab to edit macros, or learn how to change macro security settings.
Excel 2013
Didn't find what you were looking for?Search all of Office.com