Hidden Macros

[Joe Pifer]

I have an excel worksheet, it is about 2 mb. CReaed in
Excel 2000. The customer said the file was corrupted by a
virus some time ago, since then when you open it it asks
if you want to enable or disable macros. Disabling worked
up till today, the file opens then closes as excel
generates an error and closes. No Dr.Watson, nothing in
the event log. I can successfully open the file in excel
2002 and it still see macros. I open the VB editor and
there is nothing in there. What could be causing this
problem???

Thanks,
Joe

 

[Ron de Bruin]

Maybe there is a empty module??

Alt-F11
If you see one right click on it and choose Remove
Say no to export

 

[Ron de Bruin]

See this also
http://www.contextures.com/xlfaqMac.html#NoMacros