Excel XP

[Guest]

I am working on a file that at one time had a macro. I deleted the macro and
saved the document however, everytime I open the document it asks me if I
want to enable the macro. I have my security setting on medium...I am not
sure why it asks me this if there are no longer any macros in the document.

 

[Jason Morin]

Probably the module in which the macro resided still
exists. Remove the module and it should stop the message.

HTH
Jason
Atlanta, GA

 

[Kostis Vezeridis]

Did you delete the code but left the module? Excel will ask for enabling
macros if it sees any user-created module, even if it is empty.

HTH
Kostis Vezerides

I am working on a file that at one time had a macro. I deleted the macro and
saved the document however, everytime I open the document it asks me if I
want to enable the macro. I have my security setting on medium...I am not
sure why it asks me this if there are no longer any macros in the

document.

 

[Guest]

Thanks...how do I remove the module?

Probably the module in which the macro resided still
exists. Remove the module and it should stop the message.

HTH
Jason
Atlanta, GA

 

[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:

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

 

[Jason Morin]

Press ALT+F11 and right-click on the module and
select "Remove ModuleX".

Jason