Never forget the macro

[Knut Olsen-Solberg]

I made a macro, and then deleted it. But ever since then, when I open
this file, Excel tells me the file contains a macro, and asks if it
should be activated.
How can I make Excel forget the damned macro?

Regards Knut

 

[Frank Stone]

hi
You may have deleted the macro but not the module.
Open the vb editor (alt+F11). in the left pane, click to
expand your project. if a module is present, double click
it. if the right pane is empty the delete the module.
right click the module then click remove module.
Regards
Frank

 

[Frank Kabel]

Hi
you also have to remove the (empty) code modules. See:
http://www.contextures.com/xlfaqMac.html#NoMacros