Macro warning when no macros

[Guest]

Excel XP, Windows 2000

I have a worksheet that formerly had recorded macros (not VBA) in it.

I deleted all the macros (none show up in Tools/Macro.../Macros), then saved
and closed the file.

When I come back in, I still get the warning about macros in the file.

Any ideas on how to really clean out the macros so that warning no longer
appears? (Interestingly, I had some VBA code in another file and deleted the
VBA - no warning.)

Thanks for any suggestions.

Allison

 

[Guest]

Make sure you delete all the names that may still be lingering. Go to the
insert menu, select name, then define. If there are any names remaining
you'll be able to delete them there.
Eloy

 

[Frank Kabel]

Hi
also delete the empty modules and check the workbook / worksheet
modules. See:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Guest]

Thanks Eloy, but that wasn't the culprit (no names are there). Any other
suggestions?

Allison

 

[Gord Dibben]

Allison

You have left-over empty module(s) you must get rid of.

See Debra Dalgleish's site for info on this.

Gord Dibben Excel MVP

 

[Guest]

Thanks Frank for the pointer. This information worked perfectly!

Allison

 

[Guest]

Thanks Gord. I got the URL from Frank's post and it works perfectly!

Allison

 

[Tom Ogilvy]

The procedures described are for VBA macros. I thought you said they were
not VBA macros?

 

[Gord Dibben]

What! No URL in my post.

So strange. How could I have forgotten that<g>

Gord Dibben Excel MVP