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?

Terry

Chip Pearson has written code for deleting modules and code.

http://www.cpearson.com/excel/vbe.htm

Gord Dibben Excel MVP

On Tue, 31 Aug 2004 17:44:03 -0700, "Terry Lowe"
wrote:

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?