This article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 84,131 times.
Learn more...
This How.com.vn teaches you how to see a list of macros in your Excel workbook, as well as how to view each macro's details in the Visual Basic Editor. Before you can work with macros, you'll need to enable the Developer tab in Excel—fortunately, this is super easy to do.
Steps
- Open a workbook in Excel. You can double-click the name of the workbook to open it in Excel. Alternatively, open Excel first from the Windows Start menu or your Mac's Applications folder, click Open, and then double-click the file.[1]
- Enable the Developer tab. If the Developer tab is enabled, it'll be in the menu bar at the top of Excel. If you don't see it, here's how to enable it:
- Windows:
- Click the File menu and select Options.
- Click Customize Ribbon.
- Select Main Tabs from the "Customize the ribbon" drop-down menu.[2]
- Check the box next to Developer and click OK.
- macOS:
- Click the Excel menu and select Preferences.[3]
- Select Main Tabs under "Customize the Ribbon."
- Check the box next to Developer.
- Click Save.
Advertisement - Windows:
- Click the Developer tab. It's at the top of Excel.
- Click Macros. It's on the left side of the toolbar. This displays a list of macros in all open workbooks by default.[4]
- To see macros in a particular workbook only, select that workbook's name from the "Macros in" menu.
- Select a macro and click Edit. This displays the macro in the Visual Basic Editor.[5]
Expert Q&A
Video
Tips
References
- ↑ https://edu.gcfglobal.org/en/excel/creating-and-opening-workbooks/1/
- ↑ https://support.microsoft.com/en-us/topic/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45
- ↑ https://support.microsoft.com/en-us/office/use-the-developer-tab-to-create-or-delete-a-macro-in-excel-for-mac-5bd3dfb9-39d7-496a-a812-1b5e8e81d96a
- ↑ https://support.microsoft.com/en-us/office/edit-a-macro-ed9e8c3d-58fd-47a1-83eb-bdee680376bb
- ↑ https://support.microsoft.com/en-us/office/edit-a-macro-ed9e8c3d-58fd-47a1-83eb-bdee680376bb
About This Article
1.Open a workbook.
2.Click the Developer tab.
3.Click Macros.
4.Select a Macro.
5.Click Edit.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.