Can't remove Macro from file

Posted by JC on October 19, 2001 8:33 AM

I have an excel file that has a macro embedded in the file. Every time the file is opened the user recieves the "Enable Macros" prompt. The problem is I have no idea where the macro is, or how to remove it(them).

Can someone help here?

Thanks

Posted by EDDIE G on October 19, 2001 10:11 AM

Go to Tools, Macros, Visual Basic Editor, then choose view, choose project explorer. in the box on the righthand side, click the plus sign next to the workbook name, then open the modules folder, right click the module you want to delete then click no for the export question. this will remove macros.

Posted by JC on October 19, 2001 12:09 PM

Ok, the problem is that there are no modules. Yet I'm still getting the prompt for the Macros. Any ideas?

Posted by Juan Pablo on October 19, 2001 12:16 PM

Dobleclick on the Sheets or in the Workbook (In the Visual Basic editor, the macro should be in one of those)

Juan Pablo

Posted by Juan Pablo on October 19, 2001 12:17 PM

Dobleclick on the worksheets or in the workbook (In the VB Editor), the macro should be in one of these.

Juan Pablo

Posted by JC on October 19, 2001 2:11 PM

Thanks! Simple solution for a simple problem....