Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Removal
Fellow Supporties,
Using Excel 97 I've created a simple macro and have since deleted it. However, when I open the workbook I'm prompted with "enable/disable" macros. I do not wish to shut off this feature for all workbooks, simply this particular one. In other words, I want this workbook to appear as if it never had a macro added. Is there a way to "totally remove" the macros? Thanks in advance, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Removal
hi,
The workbook still has the empty module in it. open the vb editor (alt+F11) In the left pane, delete any and all modules in the workbook. that will stop you enable/disable message. regards Frank -----Original Message----- Fellow Supporties, Using Excel 97 I've created a simple macro and have since deleted it. However, when I open the workbook I'm prompted with "enable/disable" macros. I do not wish to shut off this feature for all workbooks, simply this particular one. In other words, I want this workbook to appear as if it never had a macro added. Is there a way to "totally remove" the macros? Thanks in advance, David . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removal of Zero | Excel Worksheet Functions | |||
Macro removal | Excel Discussion (Misc queries) | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
Sheet removal...help please | Excel Discussion (Misc queries) | |||
Macro Deletion/Removal | Excel Programming |