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! *