How to Delete a Macro in Excel

You may find that you want to delete one or more macros that have been created in your Microsoft Excel 2007 spreadsheet. The "Macro" dialog box is used to select and delete each macro you want to delete from the workbook.

Difficulty: Easy

Instructions

Things You'll Need:

• Microsoft Excel 2007

1. Start Microsoft Excel 2007, and open a spreadsheet from your files that contains at least one macro that you want to delete.

2. Select the "Developer" tab from the top of the Excel screen. The "Developer" ribbon will be displayed just under the tab.

3. Find the "Code" group in the "Developer" ribbon and click the "Macros" button. The "Macro" dialog box will open onto your Excel screen.

4. Choose the name of the macro you want to delete from the list that appears in the "Macro" dialog box. The macro name will be highlighted in black once it is selected.

5. Click the "Delete" button on the right side of the "Macro" dialog box to instruct Excel to delete the selected macro. A dialog box will appear asking you if you are sure you want to delete the selected macro.

6. Choose the "Yes" button to confirm that you want to delete the selected macro. The macro name will be deleted from the list in the "Macro" dialog box and the dialog box will close.

7. Repeat the steps above to delete any additional macros from the open spreadsheet.