Still getting Macro Security Warning Message after removing Macro

[stef]

Excel 2002 SP3
Win XP Pro SP2

Hi,

I had a macro in a spreadsheet which I ended up not needing.

I removed it by going to VB Editor and removing the module containing
the macro.

However, I am STILL getting the Macro Security Warning when opening up
the spreadsheet.

How do I get rid of the warning? Or Could there be any trace of the
macro left causing this warning?

When going to View Macros (Alt+F8) that is blank/empty.

Thanks.

 

[Pete_UK]

Go into the VBE once more (Alt-F11) and check if Modules is showing in
the Project Explorer Window. If so, then right-click on the module and
click on Remove Module - Excel will ask if you want to Export the
module before deleting it, and you should click on No. Then save the
file and next time you open it you should not get the macro warning
message.

Hope this helps.

Pete

 

[Debra Dalgleish]

There are instructions here for checking all the modules, including the
sheet and workbook modules.

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

 

[stef]

Deb,

Even though I had removed the module, I still had some snippets of codes
in there that I deleted.
All is well now.
Thanks.