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:
http://www.contextures.com/xlfaqMac.html#NoMacros
Evan wrote:
I am working on a file that at one time had a macro. I deleted the macro and
saved the document however, everytime I open the document it asks me if I
want to enable the macro. I have my security setting on medium...I am not
sure why it asks me this if there are no longer any macros in the document.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html