Macro warning - but macros were removed!

[Hall]

My xls file had macros. So when I opened it, I got the standard warning
about if I wanted to enable or disable its macros when opening it.

I removed all the macros and closed up.

But I still get that warning whenever I open the file. Is there another
step to clean this up?

 

[Andy Wiggins]

1) Ensure you have deleted the modules
2) Check that there is nothing in ThisWorkbook or any of the sheet-specific
modules.

Even blank lines can make this message come up.
--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Debra Dalgleish]

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, and a link to Chip Pearson's macro to remove all VBA
code in a workbook:

http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Jerry W. Lewis]

The preceding replies deal with the usual causes and resolutions. But,
if the problem still remains, then try

http://groups.google.com/groups?threadm=etcItvDs$GA.194@cppssbbsa04

In some versions, hidden names left by Solver could trigger the warning.

Jerry