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 |
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 . |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com