You are viewing the article How to Delete Macros in Excel at Lassho.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
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 14,625 times.
In this article, the wikiHow will show you how to delete macros in a Microsoft Excel spreadsheet from the spreadsheet settings on both Mac and Windows computers.
Steps
On Windows
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/40/Remove-a-Macro-in-Excel-Step-1.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/40/Remove-a-Macro-in-Excel-Step-1.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight”:410,”licensing”:” <div class=”mw-parser-output”></div>”}
Open an Excel sheet with macros enabled. Double-click the Excel file that contains the macro you want to delete to open it in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/96/Remove-a-Macro-in-Excel-Step-2.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/96/Remove-a-Macro-in-Excel-Step-2.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Enable Content in the yellow bar at the top of the window to enable macros embedded in the file.
- If not enabled, you will not be able to delete the macro.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d2/Remove-a-Macro-in-Excel-Step-3.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d2/Remove-a-Macro-in-Excel-Step-3.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:262,”bigWidth”:728,”bigHeight”:414,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the View tab on the green ribbon at the top of the Excel window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d6/Remove-a-Macro-in-Excel-Step-4.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d6/Remove-a-Macro-in-Excel-Step-4.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Macros . It’s the drop-down icon
{“smallUrl”:”https://www.wikihow.com/images_en/8/82/Android7dropdown.png”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/82/ Android7dropdown.png/30px-android7dropdown.png”,”smallWidth”:460,”smallHeight”:460,”bigWidth”:30,”bigHeight”:30,”licensing”:”<div class=”mw-parser-output “></div>”}
on the far right of the View tab. A menu will be dropped down.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e5/Remove-a-Macro-in-Excel-Step-5.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e5/Remove-a-Macro-in-Excel-Step-5.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the View Macros option in the drop-down menu. The Macros window will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a3/Remove-a-Macro-in-Excel-Step-6.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a3/Remove-a-Macro-in-Excel-Step-6.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:411,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the “Macros in” drop-down box located at the bottom of the window. A new menu will be dropped down.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/69/Remove-a-Macro-in-Excel-Step-7.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/69/Remove-a-Macro-in-Excel-Step-7.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight”:410,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the All Open Workbooks option in the drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b9/Remove-a-Macro-in-Excel-Step-8.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b9/Remove-a-Macro-in-Excel-Step-8.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Select any macro. Click the name of the macro that you want to delete.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/13/Remove-a-Macro-in-Excel-Step-9.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/13/Remove-a-Macro-in-Excel-Step-9.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the Delete button on the right side of the window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/54/Remove-a-Macro-in-Excel-Step-10.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/54/Remove-a-Macro-in-Excel-Step-10.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:411,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Yes when prompted to remove the macro from your workbook.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3e/Remove-a-Macro-in-Excel-Step-11.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3e/Remove-a-Macro-in-Excel-Step-11.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-11.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight”:410,”licensing”:” <div class=”mw-parser-output”></div>”}
Save changes by pressing Ctrl + S . This step ensures that the macro is completely deleted even after you close Excel.
On a Mac
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/42/Remove-a-Macro-in-Excel-Step-12.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/42/Remove-a-Macro-in-Excel-Step-12.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-12.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Open an Excel sheet with macros enabled. Double-click the Excel file that contains the macro you want to delete to open it in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/46/Remove-a-Macro-in-Excel-Step-13.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/46/Remove-a-Macro-in-Excel-Step-13.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-13.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:411,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Enable Content on the yellow bar at the top of the Excel window. Macros embedded in the file will be activated.
- You cannot delete without macros enabled.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c3/Remove-a-Macro-in-Excel-Step-14.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c3/Remove-a-Macro-in-Excel-Step-14.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-14.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the Tops menu at the top of your Mac screen. A menu will be dropped down.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/73/Remove-a-Macro-in-Excel-Step-15.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/73/Remove-a-Macro-in-Excel-Step-15.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-15.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Select Macros at the bottom of the Tops menu. A new menu will be opened to the right of the original menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Remove-a-Macro-in-Excel-Step-16.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-16.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/Remove-a-Macro-in-Excel-Step-16.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-16.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Macros… in the menu that just opened to open the “Macros” window. [1] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0d/Remove-a-Macro-in-Excel-Step-17.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-17.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0d/Remove-a-Macro-in-Excel-Step-17.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-17.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight”:410,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the “Macros in” drop-down box near the bottom of the “Macros” window. A new menu will be dropped down.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f0/Remove-a-Macro-in-Excel-Step-18.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-18.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f0/Remove-a-Macro-in-Excel-Step-18.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-18.jpg”,”smallWidth”:460,”smallHeight”:259,”bigWidth”:728,”bigHeight”:410,”licensing”:” <div class=”mw-parser-output”></div>”}
Click All Open Workbooks in the drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1e/Remove-a-Macro-in-Excel-Step-19.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-19.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1e/Remove-a-Macro-in-Excel-Step-19.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-19.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:411,”licensing”:” <div class=”mw-parser-output”></div>”}
Select any macro. Click the name of the macro that you want to delete.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2f/Remove-a-Macro-in-Excel-Step-20.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-20.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2f/Remove-a-Macro-in-Excel-Step-20.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-20.jpg”,”smallWidth”:460,”smallHeight”:260,”bigWidth”:728,”bigHeight”:411,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the button — below the list of macros.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2d/Remove-a-Macro-in-Excel-Step-21.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-21.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2d/Remove-a-Macro-in-Excel-Step-21.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-21.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Yes when prompted to delete the selected macro.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/04/Remove-a-Macro-in-Excel-Step-22.jpg/v4-460px-Remove-a-Macro- in-Excel-Step-22.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/04/Remove-a-Macro-in-Excel-Step-22.jpg/ v4-728px-Remove-a-Macro-in-Excel-Step-22.jpg”,”smallWidth”:460,”smallHeight”:258,”bigWidth”:728,”bigHeight”:409,”licensing”:” <div class=”mw-parser-output”></div>”}
Save your changes with the key combination ⌘ Command + S . Macros will be deleted completely.
Advice
- On a Mac, you can also open the “Macros” window from the Developer tab by clicking Macros .
Warning
- Macros can damage your computer. Unless the source is known (such as created by a trusted colleague), you should not run macros from a file you did not create yourself.
X
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 14,625 times.
In this article, the wikiHow will show you how to delete macros in a Microsoft Excel spreadsheet from the spreadsheet settings on both Mac and Windows computers.
Thank you for reading this post How to Delete Macros in Excel at Lassho.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: