How to Delete Macro in MS Excel 2016?

Macro is an action or group of actions that is recorded, and it can be played back again as many times as required. The actions in macro can be a keystroke, mouse movements, typing text, or modifying text. In this article, we will discuss How to Delete Macro in MS Excel 2016? If you want to delete a macro that belongs to Personal Macro Workbook. Then you need to first unhide the workbook to delete that macro.

Steps to Delete Macro in MS Excel 2016:

Step 1: Open an Excel worksheet from which you want to delete macros. Go to the View tab in the ribbon. Under Macros group you have a Macros drop down button. Click the drop down arrow.

Step 2: When you click Macros, it provide three options:

View Macros: It shows you the list of the already created macro if any.
Record Macros: Selecting this option allows you to create your own macro that you can play back again.
Use Relative References: Selecting this will record the macros with the actions relative to the initially selected cell.

As now I need to view the list of macros. So that I can decide which macro to delete. Hence, I chose View Macros.

Step 3: A Macro dialog box is opened. Under Macro name: it shows the list of all the created macros. Now, here I want to delete the macro Highlight. So I will select Highlight from the list. Now you have to decide whether you want to remove the macro from All Open Workbooks or only from  This Workbook. I selected from This Workbook as I want to remove this from this workbook only. Click on Delete.

Step 4: A Microsoft Excel dialog box is opened. It confirms whether you want to delete the Highlight macro or not. To confirm click Yes.

Thank you. Hope the content is useful. Keep reading