Dibben,
I've tried to choose "yes", ie, enable the macor. It was just the
same. The file wasnt open and it was blank in excel. I've tried
several times with both "no" and "yes". The problem, I think, is that
I just couldn't open the file and look up in the vb editor window.
I almost felt a little frustrated so I want to attach the file in
trouble here and let you have a look.
Thanks a lot!
Militant



On Tue, 26 Apr 2005 09:16:29 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

militant

When you open the workbook, you must select "yes" to enable macros.

Then follow Debra's instructions to delete the module.

Not a version issue........2000 same as 2002 and 2003.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 15:31:47 +0800, militant wrote:

I followed your link to the FAQ. However, I found it didn't work for
me. As I chose to enable or disable the macro, the file wasn't opened.
It was blank in excel. So I couldn't edit any vb code or module to the
file I want to open, let alone remove something.
From the looks of pane in that page, I felt maybe that is in Excel Xp
or 2003 and I am using excel 2000, it that the problem?
Thanks and Regards, Dalgleish
Militant


On Tue, 26 Apr 2005 00:52:39 -0400, Debra Dalgleish
wrote:

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