MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Get rid of macro warning, since there is no macro


Posted by RichT on October 04, 2001 11:11 AM

How can I get Excel to stop warning me about the danger of macros when I open a particular file that HAD a macro in it but has since been deleted? I don't want to turn this warning off, I just want it to realize there is no longer a macro in that file.


Posted by Barrie Davidson on October 04, 2001 11:19 AM

Rich, there's a couple of places that you need to look for code. Check the Workbook's code and each individual Worksheet's code. I'll bet you've got some code buried in there somewhere.

Regards,
BarrieBarrie Davidson

Posted by gregc on October 04, 2001 11:32 AM

Delete the module that the macro was in

When you delete a macro the module it was in is still there. If you delete the module the warning will go away.