Macro won't go away!
 

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

Macro won't go away!
 

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.

"Arsenio Oloroso" wrote:

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

Macro won't go away!
 

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

Arsenio Oloroso wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Macro won't go away!
 

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

Arsenio Oloroso wrote:

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

--

Dave Peterson

Macro won't go away!
 

thanks so much to all who responded!


"kassie" wrote in message
...
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.

"Arsenio Oloroso" wrote:

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