View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry Lowe[_3_] Terry Lowe[_3_] is offline
external usenet poster
 
Posts: 1
Default 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?