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



militant wrote:
I'm a beginner with excel macro. I tried to write a macro and soon I
found I couldn't finish it so I just determined to delete it to get
out. Then when I open the file, a message poped up, reading that there
is a macro in this file, you can cancel, start it,blah,blah. As I've
deleted the macro and I am sure there is no other macros in this file,
I am confused. I tried to cancel and start the macro, it said "module
unfound" under both options and the file couldn't be opened. As this
file contained some important info for me, can someone offer some
help?
Thanks,
Militant


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html