MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macros when none exist


Posted by Dan on January 11, 2001 9:28 PM

I have a spreadsheet that does not contain any macros but whenever I open it I am asked the question "Do I want to enable macros."

I believe at one time a macro was used on this sheet but it was removed.

Any help?


Posted by tommy m. on January 12, 2001 5:13 AM

A while back we had the same problem. It turned out to be a small virus. Run your scan and see if that helps. Or I you are using any object from the VBA toolbox such as a label or checkbox. You may not have any macros but the msgbox still comes up when those objects are used.

Posted by Jimmy on January 12, 2001 5:15 AM

Right click one sheet tab, select view code, under view select project explorer. Under that workbook you should have a folder called modules. open the modules folder and right click on any module in it, select remove module, when promoted to save select no, if you don't to save the module. That should do it.