Macro warning - but macros were removed!

  • Thread starter Thread starter Hall
  • Start date Start date
H

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?
 
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"
 
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
 
Back
Top