Hi, All

Is it possible to protect current VBA Project with a password in VBA?

There is a Protection Property of VBProject Object in "Microsoft Visual
Basic for Application Extensibility", but where i could set the password?

Right click the VBA project in the project view.
Select VBA Project properties.
Click the Protection tab.
Check lock for viewing and then provide password.

the next time you open the project you will be prompted to supply the
passowrd.

"OKLover" wrote:

Hi, All

Is it possible to protect current VBA Project with a password in VBA?

There is a Protection Property of VBProject Object in "Microsoft Visual
Basic for Application Extensibility", but where i could set the password?

The only way to assign a password with code is by using Sendkeys. I've
never done it but others have reported that it works.

--
Jim
"OKLover" wrote in message
...
| Hi, All
|
| Is it possible to protect current VBA Project with a password in VBA?
|
| There is a Protection Property of VBProject Object in "Microsoft Visual
| Basic for Application Extensibility", but where i could set the password?

Jim Rech you mentioned that
(but others have reported that it works)

Colud you please let me know when you get it ?
i.e. Is it possible to protect current VBA Project with a password i
VBA

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=39290

idea ******************

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=39290