Deleting macro code programatically

  • Thread starter Thread starter Terry Lowe
  • Start date Start date
T

Terry Lowe

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting macro code programatically 13
Excel 2003 - VBA to get a list of Module names in the project 4
Programatically changing the macro content. 1
Saving a Word document as PDF from en Excel macro 2
Make code aware of the workbook file name 3
Assign macro 2
programatically deleted code still triggers macro warning 4
assigning macro 2

Back
Top