Delete a macro
Do one of the following:
Open the workbook that contains the macro that you want to delete.
If the macro that you want to delete is stored in the personal macro workbook (Personal.xlsb), and this workbook is hidden, do the following to unhide the workbook:
On the View tab, in the Window group, click Unhide.
Under Unhide workbooks, click PERSONAL, and then click OK.
In the Macros in list, select the workbook that contains the macro that you want to delete. For example, click This Workbook.
In the Macro name box, click the name of the macro that you want to delete.
Click Delete.
Bookmarks