VBA extensibility library for deleting forms, modules, code etc...

[Guest]

I am looking to deleting all code (foms, modules etc) from the template
before closing. Chip Pearson examples/code from
http://www.cpearson.com/excel/vbe.htm
was very helpful in achieving the same.

Now i need to distribute this template to the users...but it won't work
unless
1) VBA extensibility library is referenced
2) In security settings i check the "Trust access to Visual Basic
Project"

Is there a way out for this situation....

Suggestions will be highly appreciated.

Thanks,

 

[Guest]

Frank, Thanks for your suggestion.

Actually i have couple of templates which are downloadable from Intranet.
Once user download on the system, template functionalty will only be
available untill it is used once. Once the values are spit on the excel
sheet...the functionality, code, data is of no use but resides in the
template. I am trying to get rid of it so that the unnecessary size gets
decreased.

Would you recommend another logic for this.

 

[Dave Peterson]

You have a suggestion at your other thread in this newsgroup.