MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to remove 'hidden' macros

Posted by Reijo on January 22, 2002 4:59 AM


I get a message that my workbook contains macros when I open it. Yet I have not, at least intentionally, made any macros in my workbook. My file is clean from viruses. In VB editor I dont see any modules. How do I remove them handily? I figured a way to copy all the sheets to a new workbook, but that is too much of a hassle.


Posted by Bariloche on January 22, 2002 5:22 AM


Open up the VBE again and double click on all the sheet objects (including "ThisWorkbook"). Code can also be placed "behind" sheets not just in modules.


Posted by Michael on January 22, 2002 5:23 AM

Do you have any buttons or Controls on you sheets (Did you have any in the past?) - When you are in the VBE, check each sheet that is listed. You probably have a Sub/End Sub on one of the sheets.

Posted by Reijo on January 24, 2002 5:01 AM


That's just what it was. Yet, I don't know how it got there.