unlocking a project in VB(A)

[Arne]

In a previous post, I asked a question about changing the
CodeName property of a worksheet. It appears that this can
be done via the vbProject property of the workbook.
However, the CodeName property can only be changed when
the project is not locked, but unfortunately it is.
Therefore my question is: is there a way to unlock the
project, providing of course that the password is known?

 

[Abdul Salam]

If you know the password by doubleclicking the module it
will ask the password and you can unlock it..

Abdul Salam

 

[Hank Scorpio]

In a previous post, I asked a question about changing the
CodeName property of a worksheet. It appears that this can
be done via the vbProject property of the workbook.
However, the CodeName property can only be changed when
the project is not locked, but unfortunately it is.
Therefore my question is: is there a way to unlock the
project, providing of course that the password is known?

No; the project would be too vulnerable to brute force cracking if
there were. You may be able to kludge a solution using the SendKeys
method or statement but I don't recommend it; it'd be too flaky to use
operationally.

 

[Arne]

yep, that's the manual way, but I want to unlock the
project (temporarily) by means of VBA, since I do not want
to hand out the password to the users of the workbook.

 

[Leo Heuser]

That's not possible.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.