Hi
for the first one: Use late binding. For the second one: no solution as this
is a security feature and you should not be able to change this via code.

"Ajit" wrote:

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,
--
Ajit