ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protect current VBA Project? (https://www.excelbanter.com/excel-programming/336371-protect-current-vba-project.html)

OKLover[_2_]

Protect current VBA Project?
 
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 F

Protect current VBA Project?
 
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?


Jim Rech

Protect current VBA Project?
 
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?



helmekki[_91_]

Protect current VBA Project?
 

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


helmekki[_92_]

Protect current VBA Project?
 

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



All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com