Excel XP

E

Evan

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.
 
J

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
 
K

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

Evan said:
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
Click to expand...
document.
 
E

Evan

Thanks...how do I remove the module?

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

HTH
Jason
Atlanta, GA
Click to expand...
 
Top