There is no way, other than using SendKeys (unreliable and not
recommended for production code) to programatically protect and
unprotect the VBProject.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ajit" wrote in message
...
I am working on a situation where there are couple of hundred
excel templates
with forms , modules etc. And i need to make a global change in
the code to
one of the procedure. I found some valuable information at
www.cpearson.com
which helped me pragramme to the Visual basic editor.

What i am doing is : I am opening the required template,
finding the
procedure which needs to be replaced , deleting that procedure
and adding a
new procedure with same name but different code.

All works well....except when VBE project is protected.

Could someone suggest a wayout to unprotect the project at
runtime ...make
the required changes and then again protect the project before
saving it.

Suggestions will be highly appreciated.

Thanks
--
Ajit