MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I purposely deleted my Macros but Excel still thinks I have them.


Posted by Marion on January 24, 2002 1:33 PM

Each time I open the fle, Excel gives me the Virus warning, thinking
the file contains macros.

But I've eliminated the macros.
How do I get rid of the cursed warning?


Posted by Ania on January 24, 2002 1:55 PM

Check if you have deleted them everywhere. Open VBA editor and check for modules, forms and etc. and remove any code left.

Posted by Marion on January 24, 2002 2:10 PM

How do I find macros in vba editor?

I don't know Excel.
I use Quattro.

I've opened VBA Editor, but I don't see anything about macros.

Where should I look?

Posted by Marion on January 24, 2002 2:12 PM

In fact, in VB Editor, if I click RUN- MACRO...

there aren't any macro listed.
Because I've already deleted them!

Posted by Ania on January 24, 2002 2:28 PM

Re: How do I find macros in vba editor?

what sheet were the macros on? are there any modules or forms?
right click and select view code. make sure that everything is blank. if there is a module - delete it.