Deleted macro

[Guest]

I created a macro in a workbook and saved the file. Each time I would open the workbook, I would get a warning about macros. I eventually deleted the macro and I still get the warnings, even though this workbook no longer contains macros. How do I get rid of the warning>

 

[Debra Dalgleish]

When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions for finding and removing code on the
following page, and a link to Chip Pearson's macro to remove all VBA
code in a workbook:

http://www.contextures.com/xlfaqMac.html#NoMacros