ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Removal (https://www.excelbanter.com/excel-programming/313420-macro-removal.html)

dfixemer

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

Frank Stone

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