How to delete a macro in Excel

You can watch a video tutorial here.

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

– Go to Developer > Macros

Step 2 – Delete the macro

– Select the macro to be deleted
– Click Delete

Step 3 – Confirm the deletion

– In the message box click OK

Step 4 – Check that the macro has been deleted

– Open the Macro window again to check that it has been deleted