Macro won't go away!

[Arsenio Oloroso]

I've deleted a macro from a workbook that didn't work correctly. It's the
only macro in the workbook. And I know it's gone because the macro list is
now empty. But whenever I open the file, I'm still confronted with the
message box that asks me whether I want to disable or enable the macros.
Can anyone tell me how to make this message go away?

thanks much
Arsenio

 

[kassie]

Press <Alt><F11> to go to VBA. Find your file and double click on it. You
will notice that although the macro has been deleted, the module which housed
the macro is still there. Click on File|Delete Module, answer No to the
question whether you want to export the macro, and it will be deleted.

 

[Debra Dalgleish]

When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions here for finding and removing code:

http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Dave Peterson]

Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Arsenio Oloroso]

thanks so much to all who responded!

Press <Alt><F11> to go to VBA. Find your file and double click on it.
You
will notice that although the macro has been deleted, the module which
housed
the macro is still there. Click on File|Delete Module, answer No to the
question whether you want to export the macro, and it will be deleted.