I'm not aware that you can programmatically lock a project. Think about it,
that could be a very slippery slope if locked projects can be unlocked
programmatically.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Alex van der Spek" wrote:

I am programmatically changing code lines to allow users to modify a
modelfunction in Excel:

So I use the VBE like:


ThisWorkbook.VBProject.VBComponents("Maincode").Co deModule.ReplaceLine 6,
CodeLine

Does anyone know how to do this and still lock the project for viewing
using a password?

Thanks!
Alex van der Spek