Kill Macro Warning (Excel 2003 SP2)

I have a worksheet in which I created two macros. I no longer need them and have deleted them. However, I still get get a security warning window when I open the worksheet that says the worksheet contains macros and I can choose to either enable or disable them, even though there are no longer any macros in the worksheet. How can I get rid of that security warning? My security setting is set at Medium and it has never been changed, either before or after I created / deleted the macros.

Re: Kill Macro Warning (Excel 2003 SP2)

Have you deleted the module that contained the macros? As long as the module remains, Excel will display the macro warning. To check:
- Open the workbook.
- Press Alt+F11 to activate the Visual Basic Editor.
- Look for the workbook in the Project Explorer on the left hand side.
- If there is a Modules node under it, expand it (if necessary).
- Right-click the module and select the option to remove it from the popup menu.
- There is no need to export the module before removing it, so click No in the prompt that appears.
- Repeat if there are more modules.
- Note: you cannot remove ThisWorkbook and the worksheet modules under Microsoft Excel Objects.
- Switch back to Excel.
- Save and close the workbook.