How to delete a macro in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-delete-a-macro-in-Excel.png)
Macros in Excel are programs that are written in a language called VBA (Visual Basic for Applications). These programs are written to automate tasks in Excel, particularly those that are performed repeatedly. Macros are usually saved with a workbook and if the workbook has the extension .xlsm, then it has a macro associated with it. If a macro is not being used, it should be deleted as it will increase the size of the file.
Step 1 – Open the Macro window
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-delete-a-macro-in-Excel.png)
– Go to Developer > Macros
Step 2 – Delete the macro
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-delete-a-macro-in-Excel.png)
– Select the macro to be deleted
– Click Delete
Step 3 – Confirm the deletion
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-delete-a-macro-in-Excel.png)
– In the message box click OK
Step 4 – Check that the macro has been deleted
![](https://spreadcheaters.com/wp-content/uploads/Step-4-How-to-delete-a-macro-in-Excel.png)
– Open the Macro window again to check that it has been deleted