You are viewing the article How to Write a Simple Macro in Microsoft Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 16,649 times.
In this article, the wikiHow will show you how to create simple macros for Excel pages.
Steps
Enable Macros
![Image titled Write a Simple Macro in Microsoft Excel Step 1](https://www.wikihow.com/images_en/thumb/b/b5/Write-a-Simple-Macro-in-Microsoft-Excel-Step-1-Version-2.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-1-Version-2.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 2](https://www.wikihow.com/images_en/thumb/b/b3/Write-a-Simple-Macro-in-Microsoft-Excel-Step-2-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-2-Version-3.jpg)
- With Excel for Mac, click the “Excel” menu.
![Image titled Write a Simple Macro in Microsoft Excel Step 3](https://www.wikihow.com/images_en/thumb/b/be/Write-a-Simple-Macro-in-Microsoft-Excel-Step-3-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-3-Version-3.jpg)
- With Excel for Mac, click and the “Preferences” menu.
![Image titled Write a Simple Macro in Microsoft Excel Step 4](https://www.wikihow.com/images_en/thumb/b/b9/Write-a-Simple-Macro-in-Microsoft-Excel-Step-4-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-4-Version-3.jpg)
- With Excel for Mac, click “Ribbon & Topbar” in the “Authoring” section.
![Image titled Write a Simple Macro in Microsoft Excel Step 5](https://www.wikihow.com/images_en/thumb/f/f1/Write-a-Simple-Macro-in-Microsoft-Excel-Step-5-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-5-Version-3.jpg)
- With Excel for Mac, the “Developer” entry is in the “Tab or Group Title” list.
![Image titled Write a Simple Macro in Microsoft Excel Step 6](https://www.wikihow.com/images_en/thumb/0/02/Write-a-Simple-Macro-in-Microsoft-Excel-Step-6-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-6-Version-3.jpg)
Macro Recording
![Image titled Write a Simple Macro in Microsoft Excel Step 7](https://www.wikihow.com/images_en/thumb/b/b6/Write-a-Simple-Macro-in-Microsoft-Excel-Step-7-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-7-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 8](https://www.wikihow.com/images_en/thumb/c/c8/Write-a-Simple-Macro-in-Microsoft-Excel-Step-8-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-8-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 9](https://www.wikihow.com/images_en/thumb/9/92/Write-a-Simple-Macro-in-Microsoft-Excel-Step-9-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-9-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 10](https://www.wikihow.com/images_en/thumb/9/96/Write-a-Simple-Macro-in-Microsoft-Excel-Step-10-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-10-Version-3.jpg)
- You can also add a description to explain the function of the macro.
![Image titled Write a Simple Macro in Microsoft Excel Step 11](https://www.wikihow.com/images_en/thumb/1/16/Write-a-Simple-Macro-in-Microsoft-Excel-Step-11-Version-2.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-11-Version-2.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 12](https://www.wikihow.com/images_en/thumb/1/14/Write-a-Simple-Macro-in-Microsoft-Excel-Step-12-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-12-Version-3.jpg)
- On a Mac, that would be ⌥ Opt + ⌘ Command + letter.
![Image titled Write a Simple Macro in Microsoft Excel Step 13](https://www.wikihow.com/images_en/thumb/3/33/Write-a-Simple-Macro-in-Microsoft-Excel-Step-13-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-13-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 14](https://www.wikihow.com/images_en/thumb/3/3e/Write-a-Simple-Macro-in-Microsoft-Excel-Step-14-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-14-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 15](https://www.wikihow.com/images_en/thumb/0/01/Write-a-Simple-Macro-in-Microsoft-Excel-Step-15-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-15-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 16](https://www.wikihow.com/images_en/thumb/8/87/Write-a-Simple-Macro-in-Microsoft-Excel-Step-16-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-16-Version-3.jpg)
- Macros can become very complex. You can even use them to open other Office programs. When recording a macro, almost everything you do in Excel is added to it.
![Image titled Write a Simple Macro in Microsoft Excel Step 17](https://www.wikihow.com/images_en/thumb/7/7b/Write-a-Simple-Macro-in-Microsoft-Excel-Step-17-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-17-Version-3.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 18](https://www.wikihow.com/images_en/thumb/6/66/Write-a-Simple-Macro-in-Microsoft-Excel-Step-18-Version-3.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-18-Version-3.jpg)
- Click the File menu and choose Save.
- Click the File Type menu below the name field.
- Click Excel Macro-Enabled Workbook.
Using macros
![Image titled Write a Simple Macro in Microsoft Excel Step 19](https://www.wikihow.com/images_en/thumb/2/2c/Write-a-Simple-Macro-in-Microsoft-Excel-Step-19.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-19.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 20](https://www.wikihow.com/images_en/thumb/a/a8/Write-a-Simple-Macro-in-Microsoft-Excel-Step-20.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-20.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 21](https://www.wikihow.com/images_en/thumb/c/ce/Write-a-Simple-Macro-in-Microsoft-Excel-Step-21.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-21.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 22](https://www.wikihow.com/images_en/thumb/c/c6/Write-a-Simple-Macro-in-Microsoft-Excel-Step-22.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-22.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 23](https://www.wikihow.com/images_en/thumb/f/f4/Write-a-Simple-Macro-in-Microsoft-Excel-Step-23.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-23.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 24](https://www.wikihow.com/images_en/thumb/4/45/Write-a-Simple-Macro-in-Microsoft-Excel-Step-24.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-24.jpg)
![Image titled Write a Simple Macro in Microsoft Excel Step 25](https://www.wikihow.com/images_en/thumb/d/d1/Write-a-Simple-Macro-in-Microsoft-Excel-Step-25.jpg/v4-728px-Write-a-Simple-Macro-in-Microsoft-Excel-Step-25.jpg)
- Click the Macros button on the Developer tab.
- Click the macro you want to view.
- Click the Edit button.
- View the macro code in the Visual Basic code editor window.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 16,649 times.
In this article, the wikiHow will show you how to create simple macros for Excel pages.
Thank you for reading this post How to Write a Simple Macro in Microsoft Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: