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.

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.

Thanks...how do I remove the module?

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.

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

Jason

-----Original Message-----
Thanks...how do I remove the module?

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.


.

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" wrote in message
...
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.

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


Evan wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html