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.
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.
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.
Thank you. Hope the content is useful. Keep reading