Deleting macro code programatically
I have a number of macros that I have written to use in
an Excel template. When a new document is created from
that template, the macros get used as a kind of one-time
use. However, to protect the code and make the documents
smaller I would like to programmatically delete all of
the macro code when the document is saved. Has anyone
ever done this and could share with me how to do it?
|