Macro Removal

[Guest]

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]

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