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?

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

Abdul Salam



-----Original Message-----
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?
.

On Tue, 29 Jul 2003 00:35:50 -0700, "Arne"
wrote:

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.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

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.

That's not possible.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"Arne" skrev i en meddelelse
...
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.