Q: Excel says there's a macro, but there isn't...

[MarkD]

Using Excel 2000.

A coworker has created a spreadhseet that, when I try to
open, it tells me that there are macros and asks if I want
them enabled or disabled.

I click on tools | macro | Macros and there's no macro
there.

I click on tools | macro | VBE and there's no modules
attached.

So, what's going on and how do I get rid of it? This seems
to be a problem with this one coworker's Excel program.

Thanks!
-Mark

 

[Andy Brown]

I click on tools | macro | Macros and there's no macro

there.

Most likely the macro has been removed but not the "parent" module. See here
http://www.contextures.com/xlfaqMac.html#NoMacros
for how to clean up.

HTH,
Andy

 

[MarkD]

Cool! That worked. Thanks Andy.

Now, do you know why this happens in the first place? I'm
wondering if my coworker's doing something that's causing
this, or if it's something inherent to her particular
Excel program.

-Mark

 

[Frank Kabel]

Hi
maybe your coworker has recorded a macro and deleted it afterwards

 

[Gord Dibben]

Mark

Expand the "Microsoft Excel Objects"

Look for lines of code in Worksheet modules and ThisWorkbook module.

Also delete any Forms and Class modules that you find.

For any I've missed, see Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

Gord Dibben Excel MVP