How to Create Macros

This How.com.vn teaches you how to create a macro in a Microsoft Office 365 program such as Word or Excel. You can record your actions to automatically create a macro in some programs, or you can use Visual Basic coding to create a macro from scratch in any Office 365 program.

Part 1

Part 1 of 3:

Enabling Developer Options

1
Open a Microsoft Office program. Macros can be created for most Office 365 programs, so open the program in which you want to create a macro.
- If you want to record a macro, open Word or Excel.
- If you want to program a macro using VBA, open Word, Excel, PowerPoint, Outlook (Windows only), or Publisher (Windows only).
- You cannot add macros to Access or OneNote.
2
Click Open other documents. It's a link in the lower-left side of the program's window. This will open a list of options on the left side of the window.
- On a Mac, click the name of your program in the upper-left corner of the screen to prompt a drop-down menu.
3
Click Options. You'll find this on the left side of the window.
- On a Mac, you'll click Preferences... in the drop-down menu.
4
Click Customize Ribbon. It's on the left side of the Options window.^{[1]XResearch source}
- On a Mac, click Ribbon & Toolbar in the Preferences window.
5
Check the "Developer" box. This box is near the bottom of the "Main Tabs" list of options.
- Depending on your selected program, you may first have to place your cursor in the "Main Tabs" pane and then scroll down to find the "Developer" box.
6
Click OK. It's at the bottom of the window. This will add the Developer tab to your selected program.
- On a Mac, you'll click Save here instead.
Advertisement

Part 2

Part 2 of 3:

Recording a Macro

Microsoft Word and Excel are the only two Office 365 programs in which you can create macros by recording steps.
2
Open a document. Click the Blank option in the upper-left side of the window to create a new, blank document, or select a document from your computer.
- You can also double-click a document to open it in its respective program (e.g., double-clicking a Word document will open it in Word).
As long as you enabled it in the last part, this tab should be at the top of the window.
It's in the top-left side of the window in the Developer toolbar.
5
Enter your macro's information. This process will vary slightly depending on your selected program:
- Word — Enter a name for the macro, select All documents as the "Store macro in" value, and click OK.
- Excel — Enter a name for the macro, add a keyboard shortcut if you like, select This Workbook as the "Store macro in" value, and click OK.
Once you click OK, any steps you take (e.g., clicks, typed text, etc.) will be added to your macro.
7
Click Stop Recording. It's in the Developer toolbar. This will save your macro and add it to your document's macro list.
- You can implement the macro by clicking Macros, selecting your macro's name, and clicking Run.
Advertisement

Part 3

Part 3 of 3:

Writing a Macro

1
Make sure you know how to code in VBA. Visual Basic for Applications (VBA) is a programming language used by Microsoft Office 365 programs to run macros.
- If you don't have a solid grasp on VBA, you may be able to find the code for an existing macro. If so, you can copy the macro's code and paste it into the VBA window later in this part.
2
Open a Microsoft Office 365 file. Double-click the file for which you want to create a macro. This will open the file in its respective program.
- You can also open the program you want to use and click the Blank option in the upper-left side of the window to create a new file.
- You cannot use Access or OneNote to create macros.
This tab is at the top of the program's window.
It's in the upper-left side of the window. Doing so opens a pop-up window.
Click the "Macro name" text box at the top of the window, then type in the name that you want to use for your macro.
It's on the right side of the window. Doing so prompts the VBA window to open.
7
Enter your macro's code. Once the VBA window opens, type in the code for your macro.^{[2]XResearch source}
- If you copied a macro's code, paste it into the VBA window.
8
Save your file as a macro-enabled format. Press either Ctrl+S (Windows) or ⌘ Command+S (Mac), then enter a file name, click the "Save as type" (Windows) or "Format" (Mac) drop-down box, and click the Macro-Enabled option in the resulting drop-down menu. You can then click Save to save the file with the macro enabled.
- You can implement the macro by clicking Macros, selecting your macro's name, and clicking Run.
Advertisement

Community Q&A

Search

Add New Question

Question
Which tab is "Macro" located in?
Community Answer
Depending on the MS Office Application, it will either be under the "View" Tab or the "Developer" Tab.
Thanks! We're glad this was helpful.
Thank you for your feedback.
If How.com.vn has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support How.com.vn
Yes No
Not Helpful 2 Helpful 8
Question
What is macros?
Tapas Mohanta
Community Answer
Macro is a short form of a word macroinstruction. You can use macros anywhere you type -- it could be word processing software like MS Word or Pages, any notepad or any IDE. You just have to find the macro option in that software or text editor and define one.
Thanks! We're glad this was helpful.
Thank you for your feedback.
If How.com.vn has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support How.com.vn
Yes No
Not Helpful 0 Helpful 3
Question
How can I use the tool bars in Microsoft Word?
Community Answer
Three of the commonly known toolbars in Microsoft Word are the Formatting, Standard, and Drawing toolbars. The Formatting toolbar contains commands for changing the appearance of text, such as bold and italics. The Standard toolbar is used to perform commonly used commands while typing, such as printing, saving, copying, and pasting. The Drawing toolbar is used to insert and edit pictures, drawings, and other graphics.
Thanks! We're glad this was helpful.
Thank you for your feedback.
If How.com.vn has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission.Support How.com.vn
Yes No
Not Helpful 2 Helpful 2

See more answers

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Video

Tips

Consider saving your macro as a button on your toolbar. You may be able to add customized commands to your toolbar, and can choose a unique button that will represent your macro.
Thanks
Helpful0 Not Helpful0

Warnings

If you create a macro that has the same name as an existing function in your software, the macro will replace that function. The software may not notify you that you are about to assign the same name to a macro that already exists.
Thanks
Helpful8 Not Helpful5