Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |