Cannot Delete Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DK - 14 Nov 2006 18:43 GMT

I inherited an excel file. When I open it, I receive a security warning for
a macro to enable or disable. I do not want any macros associated with this
file. Therefore, I did Tools, Macro, Macro and looked for the macro name -
there is not names listed to delete.

Any assistance is greatly appreciated.

Thanks,
DK

Reply to this Message

Paul B - 14 Nov 2006 18:49 GMT

Dk,
You also have to remove the modules on which the macros were stored have a
look here for details http://www.contextures.com/xlfaqMac.html#NoMacros

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> I inherited an excel file. When I open it, I receive a security warning for
> a macro to enable or disable. I do not want any macros associated with this
[quoted text clipped - 5 lines]
> Thanks,
> DK

Reply to this Message

DK - 14 Nov 2006 19:21 GMT

It worked. Thank you, thank you, thank you. I love this site:)

> Dk,
> You also have to remove the modules on which the macros were stored have a
[quoted text clipped - 12 lines]
> > Thanks,
> > DK

Reply to this Message

Dave Peterson - 14 Nov 2006 18:50 GMT

Visit Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

Signature

Dave Peterson

Reply to this Message