How to Remove All Macros in Excel 2007

1. Open up your spreadsheet workbook in Microsoft Excel.
2. Press (ALT) (F11). This will open up the VBA editor.
3. Right-click on the module associated with the macro. You'll find all of the modules that are active in your current spreadsheet in the upper left-hand corner.
4. Select 'Remove Module X,' where 'Module X' will be the name of the module you want to remove. Excel will ask if you would like to export Module X. Click 'No.'
5. Repeat steps three and four until you've removed all of the modules associated with your workbook.